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>
 <CAH2-Wznqbnc8en8+B26obp-pmTKXi_HS_h_yRt4HVtqLOCKxLQ@mail.gmail.com>
 <CAAKRu_YF9UeFnfsgDiFybAss2YQtmEHU+xjngqwmwwyQjCDvxQ@mail.gmail.com>
 <7bc8da54-fe4f-4ff2-aa4e-b54fc91df586@postgrespro.ru> <7760d3e3-15cc-4abf-ab33-027008c17d53@iki.fi>
In-Reply-To: <7760d3e3-15cc-4abf-ab33-027008c17d53@iki.fi>
From: Peter Geoghegan <pg@bowt.ie>
Date: Mon, 2 Sep 2024 17:01:54 -0400
Message-ID: <CAH2-Wzm7b-dJB7VChcdUZR9Mm6Wa5uY1k_2-h5U60XTUYdsF=w@mail.gmail.com>
Subject: Re: PG17 optimizations to vacuum
To: Heikki Linnakangas <hlinnaka@iki.fi>
Cc: Pavel Luzanov <p.luzanov@postgrespro.ru>, Melanie Plageman <melanieplageman@gmail.com>, 
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAH2-Wzm7b-dJB7VChcdUZR9Mm6Wa5uY1k_2-h5U60XTUYdsF%3Dw%40mail.gmail.com>
Precedence: bulk

On Mon, Sep 2, 2024 at 4:58=E2=80=AFPM 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).

--=20
Peter Geoghegan