Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access)

From: Kirill Reshke <reshkekirill(at)gmail(dot)com>
To: Melanie Plageman <melanieplageman(at)gmail(dot)com>
Cc: Alexander Lakhin <exclusion(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>, Xuneng Zhou <xunengzhou(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Subject: Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access)
Date: 2026-01-30 09:59:57
Message-ID: CALdSSPjnnXyJ3Ma6VTfYOT2KvOf_f6poMrPtAjNc5V2iFSE8Vw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, 30 Jan 2026 at 14:25, Kirill Reshke <reshkekirill(at)gmail(dot)com> wrote:
>
> Sorry, I messed up my previous email.
>
> > create table test_vac_unmodified_heap(a int) with (autovacuum_enabled = false);
>
> Yes I did try this, but it does not help, because autovacuum runs on
> catalog relations, still causing fail.
>
> We cannot disable autovac globally in regression suite, so I propose
> to changes this to TAp test
>

FPA POC v1

I use 'autovacuum-worker-start' injection point to 'disable'
autovacuum until test is done

--
Best regards,
Kirill Reshke

Attachment Content-Type Size
v1-0001-Reimplement-regression-tests-from-21796c267-as-TA.patch application/octet-stream 8.0 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message jian he 2026-01-30 10:10:47 Re: Can we remove support for standard_conforming_strings = off yet?
Previous Message shveta malik 2026-01-30 09:48:36 Re: Improve pg_sync_replication_slots() to wait for primary to advance