MIME-Version: 1.0
References: <3bda0d10-0d60-42b7-9600-abe23d54bb16@postgrespro.ru> <CAH2-Wz=pCtsB3v42RB5dLnzEn3tQLUJ8fJMn+si-9A8s6v=B1A@mail.gmail.com>
In-Reply-To: <CAH2-Wz=pCtsB3v42RB5dLnzEn3tQLUJ8fJMn+si-9A8s6v=B1A@mail.gmail.com>
From: Melanie Plageman <melanieplageman@gmail.com>
Date: Mon, 2 Sep 2024 13:28:49 -0400
Message-ID: <CAAKRu_aBthDxatwzR-wQ8bWfYehuxYgAO0g6AMPFyVgdOxfS4g@mail.gmail.com>
Subject: Re: PG17 optimizations to vacuum
To: Peter Geoghegan <pg@bowt.ie>
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/CAAKRu_aBthDxatwzR-wQ8bWfYehuxYgAO0g6AMPFyVgdOxfS4g%40mail.gmail.com>
Precedence: bulk

On Sun, Sep 1, 2024 at 6:00=E2=80=AFPM Peter Geoghegan <pg@bowt.ie> wrote:
>
> On Sun, Sep 1, 2024 at 5:44=E2=80=AFPM Pavel Luzanov <p.luzanov@postgresp=
ro.ru> wrote:
> > I see a perfectly working TID-store optimization.
> > With reduced maintenance_work_mem it used only one 'vacuuming indexes'
> > phase instead of 21 in v16.
> > But I also expected to see a reduction in the number of WAL records
> > and the total size of the WAL. Instead, WAL numbers have significantly
> > degraded.
> >
> > What am I doing wrong?

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.

- Melanie