Index Prefetching

Edit

ID 4351

Title Index Prefetching

Topic Performance

Created 2023-06-08 15:40:45

Last modified 2024-10-05 09:44:09 (1 month, 2 weeks ago)

Latest email 2024-11-11 20:12:20 (1 week ago)

Status

2024-11: Needs review

2024-09: Moved to next CF

2024-07: Moved to next CF

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 CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/4351
git checkout commitfest/cf/4351

Emails

index prefetching: First at 2023-06-08 15:40:12 by Tomas Vondra <tomas.vondra at enterprisedb.com>
Latest at 2024-11-11 20:12:20 by Peter Geoghegan <pg at bowt.ie>
Latest attachment (v20241106-0001-WIP-index-batching-prefetching.patch) at 2024-11-06 17:25:41 from Tomas Vondra <tomas at vondra.me>
    Attachment (v20241106-0001-WIP-index-batching-prefetching.patch) at 2024-11-06 17:25:41 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (v20240930-0001-WIP-index-batching-prefetching.patch) at 2024-09-30 21:16:25 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (v20240906-0001-WIP-index-batching-prefetching.patch) at 2024-09-06 21:49:43 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (v20240831-0001-WIP-index-batching-prefetching.patch) at 2024-08-31 20:37:31 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    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-10-05 09:44:09	Andrey Borodin (x4m)	Closed in commitfest 2024-09 with status: Moved to next CF
2024-08-01 01:45:54	Corey Huinker (coreyh)	Closed in commitfest 2024-07 with status: Moved to next CF
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

Edit