Add instrumentation showing if Heap2/PRUNE records came from VACUUM or from opportunistic pruning

Edit
ID 4288
Title Add instrumentation showing if Heap2/PRUNE records came from VACUUM or from opportunistic pruning
Topic Monitoring & Control
Created 2023-04-18 23:01:13
Last modified 2024-03-25 13:05:20 (6 months, 2 weeks ago)
Latest email 2024-03-25 14:21:14 (6 months, 2 weeks ago)
Status
2024-03: Committed
2024-01: Moved to next CF
2023-11: Moved to next CF
2023-09: Moved to next CF
2023-07: Moved to next CF
Target version
Authors Peter Geoghegan (pgeoghegan)
Reviewers Melanie Plageman (melanieplageman)Become reviewer
Committer Heikki Linnakangas (heikki)
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/4288
git checkout commitfest/cf/4288
Emails
Show various offset arrays for heap WAL records
First at 2023-01-09 21:58:42 by Andres Freund <andres at anarazel.de>
Latest at 2024-03-25 14:21:14 by Peter Geoghegan <pg at bowt.ie>
Latest attachment (v2-0001-Record-which-PRUNE-records-are-from-VACUUM.patch) at 2023-12-09 21:48:45 from Peter Geoghegan <pg at bowt.ie>
    Attachment (v2-0001-Record-which-PRUNE-records-are-from-VACUUM.patch) at 2023-12-09 21:48:45 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v1-0001-Add-rmgrdesc-README.patch) at 2023-07-10 07:44:27 from Heikki Linnakangas <hlinnaka at iki.fi> (Patch: Yes)
    Attachment (v4-0001-Fix-heapdesc-infomask-array-output.patch) at 2023-04-11 19:22:12 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v3-0001-Fix-heapdesc-infomask-array-output.patch) at 2023-04-11 18:48:18 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v2-0001-Fix-heapdesc-infomask-array-output.patch) at 2023-04-11 00:39:12 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v1-0001-Fix-heapdesc-infomask-array-output.patch) at 2023-04-10 19:18:27 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v1-0001-Fix-WAL-description-of-posting-list-updates.patch) at 2023-04-10 00:12:30 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v4-0002-Add-detail-to-some-btree-xlog-record-descs.patch) at 2023-04-07 23:21:22 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Add-rmgr_desc-utilities.patch) at 2023-04-07 21:43:24 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v1-0001-Record-which-PRUNE-records-are-from-VACUUM.patch) at 2023-04-07 20:33:08 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Record-which-PRUNE-records-are-from-VACUUM.patch) at 2023-03-21 22:37:12 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v2-0001-Add-rmgr_desc-utilities.patch) at 2023-03-13 23:00:59 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Return-block_ref-details-as-an-array.patch) at 2023-03-01 16:11:05 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Add-rmgr_desc-utilities.patch) at 2023-01-27 17:24:07 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v3-0001-heapdesc-Include-information-about-offset-arrays.patch) at 2023-01-09 21:58:42 from Andres Freund <andres at anarazel.de> (Patch: Yes)

Annotations

When Who Mail Annotation
2023-04-18 23:02:26 Peter Geoghegan (pgeoghegan) From Peter Geoghegan <pg@bowt.ie>
at 2023-03-21 22:37:12
Patch appears in thread for pg 16 work on rmgr desc routines
2023-12-09 21:51:11 Peter Geoghegan (pgeoghegan) From Peter Geoghegan <pg@bowt.ie>
at 2023-12-09 21:48:45
v2 of the patch, changes thread subject
History
When Who What
2024-03-25 13:05:20 Heikki Linnakangas (heikki) Closed in commitfest 2024-03 with status: Committed
2024-03-25 13:05:20 Heikki Linnakangas (heikki) Changed committer to heikki
2024-02-01 17:31:59 vigneshwaran C (vignesh.postgres) Closed in commitfest 2024-01 with status: Moved to next CF
2023-12-09 21:51:11 Peter Geoghegan (pgeoghegan) Added annotation "v2 of the patch, changes thread subject" to CAH2-Wzmsevhox+HJpFmQgCxWWDgNzP0R9F+VBnpOK6TgxMPrRw@mail.gmail.com
2023-12-04 09:14:10 John Naylor (john.naylor) Closed in commitfest 2023-11 with status: Moved to next CF
2023-10-05 12:17:18 Heikki Linnakangas (heikki) Removed heikki from committers
2023-10-02 17:18:46 Peter Eisentraut (petere) Closed in commitfest 2023-09 with status: Moved to next CF
2023-10-02 14:52:39 Peter Geoghegan (pgeoghegan) New status: Needs review
2023-10-02 09:21:42 Heikki Linnakangas (heikki) Closed in commitfest 2023-09 with status: Committed
2023-10-02 09:21:42 Heikki Linnakangas (heikki) Changed committer to heikki
2023-09-04 19:42:33 Melanie Plageman (melanieplageman) Added melanieplageman as reviewer
2023-08-01 21:11:07 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2023-07 with status: Moved to next CF
2023-04-18 23:02:26 Peter Geoghegan (pgeoghegan) Added annotation "Patch appears in thread for pg 16 work on rmgr desc routines" to CAH2-Wz=0ztNEy+8G3_Xj56qPfZ7eJzrHtfOtGdLavjrZJJMmeA@mail.gmail.com
2023-04-18 23:01:27 Peter Geoghegan (pgeoghegan) Changed authors to Peter Geoghegan (pgeoghegan)
2023-04-18 23:01:13 Peter Geoghegan (pgeoghegan) Attached mail thread 20230109215842.fktuhesvayno6o4g@awork3.anarazel.de
2023-04-18 23:01:13 Peter Geoghegan (pgeoghegan) Created patch record
Edit