Re: autovacuum can not remove dead tuples

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: 石勇虎 <shiyonghu651(at)pingan(dot)com(dot)cn>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: autovacuum can not remove dead tuples
Date: 2018-04-03 14:07:01
Message-ID: 5050691522764421@web14g.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello
Have you any replica with hot_standby_feedback=on ? Long transactions on such replicas will prevent vacuum. Another important option is vacuum_defer_cleanup_age on master.

regards, Sergei

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Sergei Kornilov 2018-04-03 14:18:50 Re: autovacuum can not remove dead tuples
Previous Message molofeev 2018-04-03 13:36:45 Re: BUG #15142: ERROR: MultiXactId nnnnn has not been created yet -- apparent wraparound in v9.5