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

On Sat, 31 Jan 2026 at 02:36, Melanie Plageman
<melanieplageman@gmail.com> wrote:
>
> On Fri, Jan 30, 2026 at 4:25 AM Kirill Reshke <reshkekirill@gmail.com> wrote:
> >
> > > 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
>
> Andres suggested making the table a temp table. He said other sessions
> vacuuming catalog tables shouldn't affect the temp table horizon. If
> you try that in your repro does it fix it?
>
> - Melanie


Yes indeed, it does.



--
Best regards,
Kirill Reshke