Re: Should we remove vacuum_defer_cleanup_age?
Daniel Gustafsson <daniel@yesql.se>
From: Daniel Gustafsson <daniel@yesql.se>
To: Andres Freund <andres@anarazel.de>
Cc: Justin Pryzby <pryzby@telsasoft.com>,
Alvaro Herrera <alvherre@alvh.no-ip.org>,
PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2023-03-24T20:45:06Z
Lists: pgsql-hackers
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Rework text in replication slots documentation
- 27d04ed5310a 17.0 landed
-
Remove vacuum_defer_cleanup_age
- 1118cd37eb61 16.0 landed
-
Allow read only connections during recovery, known as Hot Standby.
- efc16ea52067 9.0.0 cited
> On 24 Mar 2023, at 21:27, Andres Freund <andres@anarazel.de> wrote: > On 2023-03-23 10:18:35 +0100, Daniel Gustafsson wrote: >>> On 22 Mar 2023, at 18:00, Andres Freund <andres@anarazel.de> wrote: >> >>> It wasn't actually that much work to write a patch to remove >>> vacuum_defer_cleanup_age, see the attached. >> >> - and <xref linkend="guc-vacuum-defer-cleanup-age"/> provide protection against >> + provides protection against >> relevant rows being removed by vacuum, but the former provides no >> protection during any time period when the standby is not connected, >> and the latter often needs to be set to a high value to provide adequate >> >> Isn't "the latter" in the kept part of the sentence referring to the guc we're >> removing here? > > You're right. That paragraph generally seems a bit off. In HEAD: > > ... > > Replication slots alone don't prevent row removal, that requires > hot_standby_feedback to be used as well. > > A minimal rephrasing would be: > <para> > Similarly, <xref linkend="guc-hot-standby-feedback"/> on its own, without > also using a replication slot, provides protection against relevant rows > being removed by vacuum, but provides no protection during any time period > when the standby is not connected. Replication slots overcome these > disadvantages. > </para> +1, that's definitely an improvement. -- Daniel Gustafsson