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 (7 months, 3 weeks ago)

Latest email 2024-03-25 14:21:14 (7 months, 3 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