Postgres Pro
Downloads
Home   >   mailing lists

Re: Why doesn't Vacuum FULL update the VM - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: Why doesn't Vacuum FULL update the VM
Date
Msg-id CAH2-Wzkj5QAjsM_2D48iEQ_CzVfD1AF4boD6O39984JNm171Aw@mail.gmail.com
Whole thread Raw
In response to Why doesn't Vacuum FULL update the VM  (Melanie Plageman <melanieplageman@gmail.com>)
Responses Re: Why doesn't Vacuum FULL update the VM
List pgsql-hackers
Tree view 
On Fri, Sep 1, 2023 at 12:34 PM Melanie Plageman
<melanieplageman@gmail.com> wrote:
> I don't see why the visibility map shouldn't be updated so that all of
> the pages show all visible and all frozen for this relation after the
> vacuum full.

There was a similar issue with COPY FREEZE. It was fixed relatively
recently -- see commit 7db0cd21.

--
Peter Geoghegan

pgsql-hackers by date:

Previous
From: Vik Fearing
Date:
Subject: Re: SQL:2011 application time
Next
From: Peter Geoghegan
Date:
Subject: Re: Eager page freeze criteria clarification