Re: Write visibility map during CLUSTER/VACUUM FULL

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Anna Akenteva <a(dot)akenteva(at)postgrespro(dot)ru>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, Andres Freund <andres(at)anarazel(dot)de>, Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Write visibility map during CLUSTER/VACUUM FULL
Date: 2021-12-27 02:59:31
Message-ID: 20211227025931.GM17618@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Nov 15, 2021 at 04:38:56PM -0600, Justin Pryzby wrote:
> On Sun, Aug 29, 2021 at 07:26:42PM -0500, Justin Pryzby wrote:
> > On Mon, Jun 28, 2021 at 11:22:01AM +0300, Anna Akenteva wrote:
> > > On 2019-11-29 05:32, Michael Paquier wrote:
> > > > These comments are unanswered for more than 2 months, so I am marking
> > > > this entry as returned with feedback.
> > >
> > > I'd like to revive this patch. To make further work easier, attaching a
> > > rebased version of the latest patch by Alexander.
> > >
> > > As for having yet another copy of logic determining visibility: the
> > > visibility check was mainly taken from heap_page_is_all_visible(), so I
> > > refactored the code to make sure that logic is not duplicated. The updated
> > > patch is attached too.
> >
> > I agree that it's strange that VACUUM(FREEZE) freezes tuples but not VM bits,
> > nor page-level PD_ALL_VISIBLE (which is implied by all frozen). After FULL
> > runs (taking an exclusive lock on the table), it's necessary to then vacuum the
> > table again to get what's intended.
> >
> > Rebased on f10f0ae420ee62400876ab34dca2c09c20dcd030.
>
> Rebased this patch again
>
> Alexander, are you planning on working on this patch ?
>
> Otherwise, Anna, would you want to "own" the patch ?

Rebased on 8e1fae193864527c931a704bd7908e4fbc983f5c.

Would someone step up to "own" this patch ?

If not, its CF entry may need to be closed (there's no status for "needs
author").

Attachment Content-Type Size
v3-0001-VACUUM-FULL-CLUSTER-set-VM-and-page-level-visibil.patch text/x-diff 10.0 KB
v3-0002-refactor-the-code-to-make-sure-that-logic-is-not-.patch text/x-diff 12.4 KB
v3-0003-cluster-set-relallvisible-num_pages.patch text/x-diff 820 bytes

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Masahiko Sawada 2021-12-27 04:23:36 Re: Skipping logical replication transactions on subscriber side
Previous Message kuroda.hayato@fujitsu.com 2021-12-27 01:40:00 RE: Allow escape in application_name