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 |
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 |