public inbox for [email protected]
help / color / mirror / Atom feedFrom: Peter Geoghegan <[email protected]>
To: Pavel Luzanov <[email protected]>
Cc: Melanie Plageman <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Cc: Heikki Linnakangas <[email protected]>
Subject: Re: PG17 optimizations to vacuum
Date: Mon, 2 Sep 2024 17:17:30 -0400
Message-ID: <CAH2-Wz=G-UWRY-x+Y70c+Kz0185cX=MoJz-Vh-b6GJhTqH6jWA@mail.gmail.com> (raw)
In-Reply-To: <CAH2-Wz=dYGM1=ONVYd2jUdZP8bQy0t8G9o6PpoRWGbvbN-uPBA@mail.gmail.com>
References: <[email protected]>
<CAH2-Wz=pCtsB3v42RB5dLnzEn3tQLUJ8fJMn+si-9A8s6v=B1A@mail.gmail.com>
<CAAKRu_aBthDxatwzR-wQ8bWfYehuxYgAO0g6AMPFyVgdOxfS4g@mail.gmail.com>
<CAH2-Wznqbnc8en8+B26obp-pmTKXi_HS_h_yRt4HVtqLOCKxLQ@mail.gmail.com>
<CAAKRu_YF9UeFnfsgDiFybAss2YQtmEHU+xjngqwmwwyQjCDvxQ@mail.gmail.com>
<[email protected]>
<CAH2-Wz=dYGM1=ONVYd2jUdZP8bQy0t8G9o6PpoRWGbvbN-uPBA@mail.gmail.com>
On Mon, Sep 2, 2024 at 4:58 PM Peter Geoghegan <[email protected]> wrote:
> On Mon, Sep 2, 2024 at 4:35 PM Pavel Luzanov <[email protected]> wrote:
> > If it helps, without creating index on id column, the numbers will be
> > much closer:
>
> Yes, avoiding all index vacuuming seems useful. It makes the test case
> cleaner, since we don't have to think about the variability from the
> TIDStore work (and from index vacuuming more generally).
It just occurred to me that earlier versions don't have the
HEAP_PAGE_PRUNE_MARK_UNUSED_NOW optimization added by commit
c120550edb. Postgres 17 does have that optimization, though, so it
should easily be able to write far fewer WAL records than earlier
versions. And yet your revised no-indexes test case seems to show that
Postgres 17 is doing slightly worse by that measure (and by others).
--
Peter Geoghegan
view thread (7+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: PG17 optimizations to vacuum
In-Reply-To: <CAH2-Wz=G-UWRY-x+Y70c+Kz0185cX=MoJz-Vh-b6GJhTqH6jWA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox