Re: Reducing the WAL overhead of freezing in VACUUM by deduplicating per-tuple freeze plans
Justin Pryzby <pryzby@telsasoft.com>
From: Justin Pryzby <pryzby@telsasoft.com>
To: Peter Geoghegan <pg@bowt.ie>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2022-11-11T02:59:58Z
Lists: pgsql-hackers
On Thu, Nov 10, 2022 at 04:48:17PM -0800, Peter Geoghegan wrote:
> On Tue, Sep 20, 2022 at 3:12 PM Peter Geoghegan <pg@bowt.ie> wrote:
> > Attached is v2, which I'm just posting to keep CFTester happy. No real
> > changes here.
>
> Attached is v3. I'd like to move forward with commit soon. I'll do so
> in the next few days, barring objections.
Note that this comment is dangling in your patch:
+{
+ Page page = BufferGetPage(buffer);
+
+ /* nor when there are no tuples to freeze */
...
- /* Caller should not call me on a non-WAL-logged relation */
- Assert(RelationNeedsWAL(reln));
- /* nor when there are no tuples to freeze */
- Assert(ntuples > 0);
Commits
-
Rename and relocate freeze plan dedup routines.
- 50767705ed09 16.0 landed
-
Deduplicate freeze plans in freeze WAL records.
- 9e5405993c1e 16.0 landed