public inbox for [email protected]
help / color / mirror / Atom feedFrom: Heikki Linnakangas <[email protected]>
To: Peter Geoghegan <[email protected]>
To: Pavel Luzanov <[email protected]>
Cc: Melanie Plageman <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: PG17 optimizations to vacuum
Date: Tue, 3 Sep 2024 00:11:48 +0300
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAH2-Wzm7b-dJB7VChcdUZR9Mm6Wa5uY1k_2-h5U60XTUYdsF=w@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]>
<[email protected]>
<CAH2-Wzm7b-dJB7VChcdUZR9Mm6Wa5uY1k_2-h5U60XTUYdsF=w@mail.gmail.com>
On 03/09/2024 00:01, Peter Geoghegan wrote:
> On Mon, Sep 2, 2024 at 4:58 PM Heikki Linnakangas <[email protected]> wrote:
>> Do you have any non-default settings? "select name,
>> current_setting(name), source from pg_settings where setting <>
>> boot_val;" would show that.
>
> What about page checksums?
>
> One simple explanation is that we're writing extra FPIs to set hint
> bits. But that explanation only works if you assume that page-level
> checksums are in use (or that wal_log_hints is turned on).
Hmm, yeah, that might be it. With chceksums enabled, I see ~120k WAL
records, vs ~90k without checksums. But there's no difference between
v16 and master.
Pavel, did you test v17 with checksums enabled and v16 with checksums
disabled, by any chance?
--
Heikki Linnakangas
Neon (https://neon.tech)
view thread (5+ messages) latest in thread
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: <[email protected]>
* 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