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

Edit

Title

Topic

Monitoring & Control

Created

2023-04-18 23:01:13

Last modified

2023-12-04 09:14:10 (4 days, 23 hours ago)

Latest email

2023-10-02 09:19:29 (2 months, 1 week ago)

Status

2024-01: Needs review

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

Links

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 2023-10-02 09:19:29 by Heikki Linnakangas <hlinnaka at iki.fi>
Latest attachment (v1-0001-Add-rmgrdesc-README.patch) at 2023-07-10 07:44:27 from Heikki Linnakangas <hlinnaka at iki.fi>

    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

History

When	Who	What
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