Re: PG17 optimizations to vacuum

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Cc: Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru>, Melanie Plageman <melanieplageman(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: PG17 optimizations to vacuum
Date: 2024-09-02 21:01:54
Message-ID: CAH2-Wzm7b-dJB7VChcdUZR9Mm6Wa5uY1k_2-h5U60XTUYdsF=w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Sep 2, 2024 at 4:58 PM Heikki Linnakangas <hlinnaka(at)iki(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Heikki Linnakangas 2024-09-02 21:11:48 Re: PG17 optimizations to vacuum
Previous Message Peter Geoghegan 2024-09-02 20:58:49 Re: PG17 optimizations to vacuum