Re: Should we remove vacuum_defer_cleanup_age?
Andres Freund <andres@anarazel.de>
From: Andres Freund <andres@anarazel.de>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Justin Pryzby <pryzby@telsasoft.com>, pgsql-hackers@postgresql.org, Amit Kapila <amit.kapila16@gmail.com>
Date: 2023-04-24T20:04:34Z
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
Hi, On 2023-04-24 14:36:36 +0200, Alvaro Herrera wrote: > On 2023-Apr-22, Andres Freund wrote: > > I'm afraid we'll need TransactionIdRetreatSafely() again, when we convert more > > things to 64bit xids (lest they end up with the same bug as fixed by > > be504a3e974), so it's perhaps worth thinking about how to make it less > > confusing. > > The one thing that IMO makes it less confusing is to have it return the > value rather than modifying it in place. Partially I made it that way because you otherwise end up repeating long variable names multiple times within one statement, yielding long repetitive lines... Not sure that's a good enough reason, but ... > > > <para> > > > Replication slots overcome these disadvantages by retaining only the number > > > of segments known to be needed. > > > On the other hand, replication slots can retain so > > > many WAL segments that they fill up the space allocated > > > for <literal>pg_wal</literal>; > > > <xref linkend="guc-max-slot-wal-keep-size"/> limits the size of WAL files > > > retained by replication slots. > > > </para> > > > > It seems a bit confusing now, because "by retaining only the number of > > segments ..." now also should cover hs_feedback (due to merging), but doesn't. > > Hah, ok. > > > I think I'll push the version I had. Then we can separately word-smith the > > section? Unless somebody protests I'm gonna do that soon. > > No objection. Cool. Pushed now.