nbtree skip scan

Title

nbtree skip scan

Topic

Performance

Created

2024-06-26 19:45:36

Last modified

2024-08-01 06:07:29 (1 month, 2 weeks ago)

Latest email

2024-09-14 12:23:50 (2 days, 6 hours ago)

Status

2024-09: Needs review

2024-07: Moved to next CF

Target version

Authors

Peter Geoghegan (pgeoghegan)

Reviewers

Aleksander Alekseev (a.alekseev), Masahiro Ikeda (masahiro.ikeda)Become reviewer

Committer

Links

Emails

Adding skip scan (including MDAM style range skip scan) to nbtree: First at 2024-06-26 19:16:07 by Peter Geoghegan <pg at bowt.ie>
Latest at 2024-09-14 12:23:50 by Tomas Vondra <tomas at vondra.me>
Latest attachment (v1-0001-Fix-stuck-parallel-btree-scans.patch) at 2024-09-12 14:49:24 from Matthias van de Meent <boekewurm+postgres at gmail.com>
    Attachment (v1-0001-Fix-stuck-parallel-btree-scans.patch) at 2024-09-12 14:49:24 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (lockup2.log) at 2024-09-07 15:27:05 from Tomas Vondra <tomas at vondra.me> (Patch: No)
    Attachment (v6-0001-Show-index-search-count-in-EXPLAIN-ANALYZE.patch) at 2024-09-04 16:52:57 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v5-0001-Normalize-nbtree-truncated-high-key-array-behavio.patch) at 2024-08-09 21:13:28 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v4-0001-Add-skip-scan-to-nbtree.patch) at 2024-07-24 21:14:54 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v3-0001-Add-skip-scan-to-nbtree.patch) at 2024-07-15 18:34:38 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (compare_cost.sql) at 2024-07-12 05:18:56 from <Masahiro.Ikeda at nttdata.com> (Patch: No)
    Attachment (v2-0001-Add-skip-scan-to-nbtree.patch) at 2024-07-02 16:25:51 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (mdam_paper_in_query.sql) at 2024-06-26 19:16:07 from Peter Geoghegan <pg at bowt.ie> (Patch: No)

History

When	Who	What
2024-08-01 06:07:29	Corey Huinker (coreyh)	Closed in commitfest 2024-07 with status: Moved to next CF
2024-07-02 12:53:24	Aleksander Alekseev (a.alekseev)	Added a.alekseev as reviewer
2024-06-28 00:46:56	Masahiro Ikeda (masahiro.ikeda)	Added masahiro.ikeda as reviewer
2024-06-27 19:15:52	Peter Geoghegan (pgeoghegan)	Changed authors to Peter Geoghegan (pgeoghegan)
2024-06-26 19:45:36	Peter Geoghegan (pgeoghegan)	Attached mail thread CAH2-Wzmn1YsLzOGgjAQZdn1STSG_y8qP__vggTaPAYXJP+G4bw@mail.gmail.com
2024-06-26 19:45:36	Peter Geoghegan (pgeoghegan)	Created patch record