Re: PG17 optimizations to vacuum - Mailing list pgsql-general

From Peter Geoghegan
Subject Re: PG17 optimizations to vacuum
Date
Msg-id CAH2-Wzm7b-dJB7VChcdUZR9Mm6Wa5uY1k_2-h5U60XTUYdsF=w@mail.gmail.com
Whole thread Raw
In response to Re: PG17 optimizations to vacuum  (Heikki Linnakangas <hlinnaka@iki.fi>)
Responses Re: PG17 optimizations to vacuum
List pgsql-general
On Mon, Sep 2, 2024 at 4:58 PM Heikki Linnakangas <hlinnaka@iki.fi> 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).

--
Peter Geoghegan



pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: PG17 optimizations to vacuum
Next
From: Heikki Linnakangas
Date:
Subject: Re: PG17 optimizations to vacuum