Re: Hot Standby Conflict on pg_attribute - Mailing list pgsql-general

From Erik Jones
Subject Re: Hot Standby Conflict on pg_attribute
Date
Msg-id CABX4GUsLT-EJe8CO=v75hJ6nBrYC_J_UJcsA=4kRm1gWZGR3mQ@mail.gmail.com
Whole thread Raw
In response to Re: Hot Standby Conflict on pg_attribute  (Jeremy Schneider <schneider@ardentperf.com>)
List pgsql-general
Thanks for the ti

On Sat, May 11, 2019 at 9:15 AM Jeremy Schneider <schneider@ardentperf.com> wrote:
Just a quick footnote: If autovac truncations are frequently causing replica lag, and if this is a problem for you, IIUC one way you can stop autovac from doing the truncations even on older versions is setting old_snapshot_threshold to any value at all besides zero.  (On 12+ you can directly control the truncation behavior.)

-Jeremy

Thanks for the tip!

--

pgsql-general by date:

Previous
From: Josef Šimánek
Date:
Subject: Linked data from upgrade after VACUUM FULL not deleted.
Next
From: Bruce Momjian
Date:
Subject: Re: Linked data from upgrade after VACUUM FULL not deleted.