Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans

Edit
Comment/Review
Change Status
ID 4455
Title Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic Performance
Tags
Created 2023-07-25 02:59:08
Last modified 2024-04-06 17:22:27 (1 year ago)
Latest email 2024-04-08 02:13:57 (1 year ago)
Status
2024-03 (2024-03-01 - 2024-04-08): Committed
2024-01 (2024-01-01 - 2024-01-31): Moved to different CF
2023-11 (2023-11-01 - 2023-12-04): Moved to different CF
2023-09 (2023-09-01 - 2023-09-30): Moved to different CF
Target version
Authors Peter Geoghegan (pgeoghegan)
Reviewers Matthias van de Meent (mmeent)Become reviewer
Committer Peter Geoghegan (pgeoghegan)
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 2024-04-08 02:13:57 by Peter Geoghegan <pg at bowt.ie>
Latest attachment (v19-0001-Enhance-nbtree-ScalarArrayOp-execution.patch) at 2024-04-03 19:53:37 from Peter Geoghegan <pg at bowt.ie>
    Attachment (v19-0001-Enhance-nbtree-ScalarArrayOp-execution.patch) at 2024-04-03 19:53:37 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (v18-0001-Enhance-nbtree-ScalarArrayOp-execution.patch) at 2024-04-01 22:33:22 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (v17-0001-Enhance-nbtree-ScalarArrayOp-execution.patch) at 2024-03-26 18:01:58 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (v16-0001-Enhance-nbtree-ScalarArrayOp-execution.patch) at 2024-03-22 00:32:42 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (v1-0001-nbtree-Optimize-preprocessing-for-single-ScanKey-.patch.txt) at 2024-03-20 19:26:38 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (precheck_testcase.sql) at 2024-03-16 00:12:02 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v14-0003-_bt_merge_arrays-Use-sort-merge-join-algorithm.patch) at 2024-03-08 14:00:14 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Enhance-nbtree-ScalarArrayOp-execution.patch) at 2024-03-06 00:50:18 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (v12-0001-Enhance-nbtree-ScalarArrayOp-execution.patch) at 2024-03-02 01:30:15 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (v11-0001-Enhance-nbtree-ScalarArrayOp-execution.patch) at 2024-02-15 23:36:24 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (v11-0001-nbtree-merge-array-scankeys-s-arrays-more-effici.patch-b) at 2024-01-22 21:12:55 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Enhance-nbtree-ScalarArrayOp-execution.patch) at 2024-01-17 22:08:06 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (v9-0001-Enhance-nbtree-ScalarArrayOp-execution.patch) at 2023-12-28 17:28:32 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (v8-0001-Enhance-nbtree-ScalarArrayOp-execution.patch) at 2023-12-09 18:38:57 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    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
2024-04-06 17:22:27 Peter Geoghegan (pgeoghegan) Closed in commitfest 2024-03 with status: Committed
2024-04-06 17:22:27 Peter Geoghegan (pgeoghegan) Changed committer to pgeoghegan
2024-02-01 17:45:59 vigneshwaran C (vignesh.postgres) Closed in commitfest 2024-01 with status: Moved to next CF
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
Edit
Comment/Review
Change Status