Re: Removing more vacuumlazy.c special cases, relfrozenxid optimizations

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Removing more vacuumlazy.c special cases, relfrozenxid optimizations
Date: 2022-01-06 19:23:57
Message-ID: CAH2-WzmKpOPWtDkyr2bV7MDweEH7dGY9JjhLF2nkn0kykF0SCA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Dec 20, 2021 at 9:35 PM Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> > Given the opportunistic freezing, that's true but I'm concerned
> > whether opportunistic freezing always works well on all tables since
> > freezing tuples is not 0 cost.
>
> That is the big question for this patch.

Attached is a mechanical rebase of the patch series. This new version
just fixes bitrot, caused by Masahiko's recent lazyvacuum.c
refactoring work. In other words, this revision has no significant
changes compared to the v4 that I posted back in late December -- just
want to keep CFTester green.

I still have plenty of work to do here. Especially with the final
patch (the v5-0005-* "freeze early" patch), which is generally more
speculative than the other patches. I'm playing catch-up now, since I
just returned from vacation.

--
Peter Geoghegan

Attachment Content-Type Size
v5-0002-Improve-log_autovacuum_min_duration-output.patch application/x-patch 15.4 KB
v5-0004-Loosen-coupling-between-relfrozenxid-and-tuple-fr.patch application/x-patch 28.8 KB
v5-0005-Freeze-tuples-early-to-advance-relfrozenxid.patch application/x-patch 9.5 KB
v5-0003-Simplify-vacuum_set_xid_limits-signature.patch application/x-patch 10.8 KB
v5-0001-Simplify-lazy_scan_heap-s-handling-of-scanned-pag.patch application/x-patch 46.9 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2022-01-06 19:24:17 Re: pl/pgsql feature request: shorthand for argument and local variable references
Previous Message Tomas Vondra 2022-01-06 19:22:33 Re: Collecting statistics about contents of JSONB columns