Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans

Title

Topic

Performance

Created

2023-07-25 02:59:08

Last modified

2023-12-04 09:47:21 (3 hours, 14 minutes ago)

Latest email

2023-11-29 00:57:52 (5 days, 12 hours ago)

Status

2024-01: Needs review

2023-11: Moved to next CF

2023-09: Moved to next CF

Target version

Authors

Peter Geoghegan (pgeoghegan)

Reviewers

Matthias van de Meent (mmeent)Become reviewer

Committer

Links

Emails

Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan: First at 2023-07-25 01:33:52 by Peter Geoghegan <pg at bowt.ie>
Latest at 2023-11-29 00:57:52 by Peter Geoghegan <pg at bowt.ie>
Latest attachment (index_walk_dump.txt.bz2) at 2023-11-28 23:52:31 from Peter Geoghegan <pg at bowt.ie>
    Attachment (index_walk_dump.txt.bz2) at 2023-11-28 23:52:31 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (saop-benchmark.pdf) at 2023-11-28 12:29:27 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: No)
    Attachment (v7-0001-Enhance-nbtree-ScalarArrayOp-execution.patch) at 2023-11-21 02:52:32 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (nemesis.sql) at 2023-11-09 23:57:51 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (v6-0001-Enhance-nbtree-ScalarArrayOp-execution.patch) at 2023-11-08 01:53:01 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (v5-0001-Enhance-nbtree-ScalarArrayOp-execution.patch) at 2023-10-20 22:39:44 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v4-0001-Enhance-nbtree-ScalarArrayOp-execution.patch) at 2023-10-15 20:50:43 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (v3-0001-Enhance-nbtree-ScalarArrayOp-execution.patch) at 2023-09-29 00:32:19 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (v2-0001-Enhance-nbtree-ScalarArrayOp-execution.patch) at 2023-09-17 23:47:45 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (v1-0001-Cache-btree-scan-end-page-across-rescans-in-the-s.patch.cfbot-ignore) at 2023-07-27 13:59:51 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Enhance-nbtree-ScalarArrayOp-execution.patch) at 2023-07-25 01:33:52 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)

History

When	Who	What
2023-12-04 09:47:21	John Naylor (john.naylor)	Closed in commitfest 2023-11 with status: Moved to next CF
2023-11-06 21:28:30	Matthias van de Meent (mmeent)	Added mmeent as reviewer
2023-10-02 09:47:13	Peter Eisentraut (petere)	Closed in commitfest 2023-09 with status: Moved to next CF
2023-07-25 02:59:17	Peter Geoghegan (pgeoghegan)	Changed authors to Peter Geoghegan (pgeoghegan)
2023-07-25 02:59:08	Peter Geoghegan (pgeoghegan)	Attached mail thread CAH2-Wz=ksvN_sjcnD1+Bt-WtifRA5ok48aDYnq3pkKhxgMQpcw@mail.gmail.com
2023-07-25 02:59:08	Peter Geoghegan (pgeoghegan)	Created patch record