On 12/8/18 8:21 PM, Jeremy Finzel wrote: > There are 2.1 million files in pg_replslot which I don't think is > normal? Any ideas as to where I should be looking or what could cause this? Postgres spills changes on disk when you have a big transaction: https://blog.anayrat.info/en/2018/03/10/logical-replication-internals/ You can monitor it with check_pgactivity's replication_slots service: https://github.com/OPMDG/check_pgactivity/blob/master/check_pgactivity#L5664 (You have to use master version, this feature has not been released yet)
pgsql-hackers by date:
Соглашаюсь с условиями обработки персональных данных