MIME-Version: 1.0
References: <3bda0d10-0d60-42b7-9600-abe23d54bb16@postgrespro.ru>
 <CAH2-Wz=pCtsB3v42RB5dLnzEn3tQLUJ8fJMn+si-9A8s6v=B1A@mail.gmail.com> <CAAKRu_aBthDxatwzR-wQ8bWfYehuxYgAO0g6AMPFyVgdOxfS4g@mail.gmail.com>
In-Reply-To: <CAAKRu_aBthDxatwzR-wQ8bWfYehuxYgAO0g6AMPFyVgdOxfS4g@mail.gmail.com>
From: Peter Geoghegan <pg@bowt.ie>
Date: Mon, 2 Sep 2024 13:47:28 -0400
Message-ID: <CAH2-Wznqbnc8en8+B26obp-pmTKXi_HS_h_yRt4HVtqLOCKxLQ@mail.gmail.com>
Subject: Re: PG17 optimizations to vacuum
To: Melanie Plageman <melanieplageman@gmail.com>
Cc: Pavel Luzanov <p.luzanov@postgrespro.ru>, 
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>, Heikki Linnakangas <hlinnaka@iki.fi>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAH2-Wznqbnc8en8%2BB26obp-pmTKXi_HS_h_yRt4HVtqLOCKxLQ%40mail.gmail.com>
Precedence: bulk

On Mon, Sep 2, 2024 at 1:29=E2=80=AFPM Melanie Plageman
<melanieplageman@gmail.com> wrote:
> I'll investigate more tomorrow, but based on my initial investigation,
> there appears to be some interaction related to how much of the
> relation is in shared buffers after creating the table and updating
> it. If you set shared_buffers sufficiently high and prewarm the table
> after the update, master has fewer WAL records reported by vacuum
> verbose.

Fewer of what specific kind of WAL record?

All of the details about useful work done by VACUUM were identical
across versions. It was only the details related to WAL, buffers, and
CPU time that changed.

Perhaps I'm not thinking of something obvious. Maybe it's extra
VISIBILITY records? But I'd expect the number of VISIBILITY records to
match the number of pages frozen, given these particulars. VACUUM
VERBOSE at least shows that that hasn't changed.

--=20
Peter Geoghegan