Index Prefetching

Title

Index Prefetching

Topic

Performance

Created

2023-06-08 15:40:45

Last modified

2024-04-08 15:00:14 (2 weeks, 1 day ago)

Latest email

2024-03-05 13:00:12 (1 month, 2 weeks ago)

Status

2024-07: Needs review

2024-03: Moved to next CF

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

Tomas Vondra (fuzzycz)

Reviewers

Become reviewer

Committer

Links

Emails

index prefetching: First at 2023-06-08 15:40:12 by Tomas Vondra <tomas.vondra at enterprisedb.com>
Latest at 2024-03-05 13:00:12 by Jakub Wartak <jakub.wartak at enterprisedb.com>
Latest attachment (v4-0001-Streaming-Read-API.patch) at 2024-02-07 21:48:18 from Melanie Plageman <melanieplageman at gmail.com>
    Attachment (v4-0001-Streaming-Read-API.patch) at 2024-02-07 21:48:18 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Streaming-Read-API.txt) at 2024-01-24 20:20:28 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v20240124-0001-Prefetch-heap-pages-during-index-scans.patch) at 2024-01-24 18:13:24 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (v2-0002-use-streaming-reads-in-index-scan.nocfbot) at 2024-01-24 00:51:24 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (0002-use-streaming-reads-in-index-scan.txt) at 2024-01-19 21:43:37 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v20240112-0001-Prefetch-heap-pages-during-index-scans.patch) at 2024-01-12 16:42:39 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (v20240103-0001-prefetch-2023-12-09.patch) at 2024-01-04 14:55:01 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (v20231209-0001-prefetch-2023-11-24.patch) at 2023-12-09 18:08:20 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (v20231124-0001-prefetch-2023-10-16.patch) at 2023-11-24 16:25:52 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (index-prefetch.pdf) at 2023-10-16 15:34:44 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: No)
    Attachment (index-prefetch-v5.patch) at 2023-07-14 20:31:57 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (index-prefetch-v4.patch) at 2023-06-30 11:38:06 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0003-ignore-seq-patterns-add-stats-v3.patch) at 2023-06-19 19:27:46 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (pg_type_typname_nsp_index_index_example_log.txt) at 2023-06-08 23:38:13 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (index-prefetch-poc.patch) at 2023-06-08 15:40:12 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)

History

When	Who	What
2024-04-08 15:00:14	Andrey Borodin (x4m)	Closed in commitfest 2024-03 with status: Moved to next CF
2024-02-01 17:45:36	vigneshwaran C (vignesh.postgres)	Closed in commitfest 2024-01 with status: Moved to next CF
2023-12-04 09:22:54	John Naylor (john.naylor)	Closed in commitfest 2023-11 with status: Moved to next CF
2023-10-02 09:46:50	Peter Eisentraut (petere)	Closed in commitfest 2023-09 with status: Moved to next CF
2023-08-01 21:07:51	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2023-07 with status: Moved to next CF
2023-06-10 12:08:00	James Coleman (jcole1989)	Changed authors to Tomas Vondra (fuzzycz)
2023-06-08 15:40:45	Tomas Vondra (fuzzycz)	Attached mail thread cf85f46f-b02f-05b2-5248-5000b894ebab@enterprisedb.com
2023-06-08 15:40:45	Tomas Vondra (fuzzycz)	Created patch record