| From: | Peter Geoghegan <pg(at)bowt(dot)ie> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, 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-02-12 04:30:30 |
| Message-ID: | CAH2-WzkUBbg9SSL7bFWT_Y86027GAUJEgqwgbe2YjOLEpw9ysQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sat, Jan 29, 2022 at 8:42 PM Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> Attached is v7, a revision that overhauls the algorithm that decides
> what to freeze. I'm now calling it block-driven freezing in the commit
> message. Also included is a new patch, that makes VACUUM record zero
> free space in the FSM for an all-visible page, unless the total amount
> of free space happens to be greater than one half of BLCKSZ.
I pushed the earlier refactoring and instrumentation patches today.
Attached is v8. No real changes -- just a rebased version.
It will be easier to benchmark and test the page-driven freezing stuff
now, since the master/baseline case will now output instrumentation
showing how relfrozenxid has been advanced (if at all) -- whether (and
to what extent) each VACUUM operation advances relfrozenxid can now be
directly compared, just by monitoring the log_autovacuum_min_duration
output for a given table over time.
--
Peter Geoghegan
| Attachment | Content-Type | Size |
|---|---|---|
| v8-0003-Add-all-visible-FSM-heuristic.patch | application/x-patch | 2.5 KB |
| v8-0002-Make-block-level-characteristics-drive-freezing.patch | application/x-patch | 11.8 KB |
| v8-0001-Loosen-coupling-between-relfrozenxid-and-tuple-fr.patch | application/x-patch | 30.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2022-02-12 04:38:45 | Re: pgsql: Add suport for server-side LZ4 base backup compression. |
| Previous Message | Michael Paquier | 2022-02-12 04:29:54 | Re: pgsql: Add TAP test to automate the equivalent of check_guc |