Re: PG17 optimizations to vacuum

2024-09-02 Thread Heikki Linnakangas
On 03/09/2024 00:11, Heikki Linnakangas wrote: On 03/09/2024 00:01, Peter Geoghegan wrote: On Mon, Sep 2, 2024 at 4:58 PM Heikki Linnakangas wrote: Do you have any non-default settings? "select name, current_setting(name), source  from pg_settings where setting <> boot_val;"

Re: PG17 optimizations to vacuum

2024-09-02 Thread Heikki Linnakangas
ump -p data/pg_wal/ -s 1/F4474498 --stats=record where "1/F4474498" is the position printed by the "SELECT pg_current_wal_insert_lsn()" above. Do you have any non-default settings? "select name, current_setting(name), source from pg_settings where setting <> b

Re: PG17 optimizations to vacuum

2024-09-02 Thread Heikki Linnakangas
On 03/09/2024 00:01, Peter Geoghegan wrote: On Mon, Sep 2, 2024 at 4:58 PM Heikki Linnakangas 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 checks

Re: PG17 optimizations to vacuum

2024-09-03 Thread Heikki Linnakangas
On 03/09/2024 10:34, Pavel Luzanov wrote: On 03.09.2024 00:11, Heikki Linnakangas wrote: Pavel, did you test v17 with checksums enabled and v16 with checksums disabled, by any chance? Exactly, You are right! My v16 cluster comes from the default Ubuntu distribution. I forgot that checksums