Index Prefetching

Edit

4351

Title

Index Prefetching

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v1, Patch count: 1, First patch: +480−2, All patches: +480−2

Topic

Performance

Tags

Created

2023-06-08 15:40:45

Last modified

2025-04-02 18:15:42 (3 months ago)

Latest email

2025-07-25 00:44:05 (20 hours ago)

Status

PG19-1 (2025-07-01 - 2025-07-31): Waiting on Author

2025-03 (2025-03-01 - 2025-04-08): Moved to different CF

2025-01 (2025-01-01 - 2025-01-31): Moved to different CF

2024-11 (2024-11-01 - 2024-11-30): Moved to different CF

2024-09 (2024-09-01 - 2024-09-30): Moved to different CF

2024-07 (2024-07-01 - 2024-07-31): Moved to different CF

2024-03 (2024-03-01 - 2024-04-08): Moved to different CF

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

2023-07 (2023-07-01 - 2023-07-31): Moved to different 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 2025-07-25 00:44:05 by Peter Geoghegan <pg at bowt.ie>
Latest attachment (v2-0001-pgstattuple-analyze-TIDs-on-btree-leaf-pages.patch) at 2025-07-24 23:52:22 from Tomas Vondra <tomas at vondra.me>
    Attachment (v2-0001-pgstattuple-analyze-TIDs-on-btree-leaf-pages.patch) at 2025-07-24 23:52:22 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (v1-0001-pgstattuple-analyze-TIDs-on-btree-leaf-pages.patch) at 2025-07-24 11:19:07 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (batches-64.log) at 2025-07-23 16:55:02 from Tomas Vondra <tomas at vondra.me> (Patch: No)
    Attachment (prefetch-distance-explain.patch) at 2025-07-23 12:50:15 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (0003-aio-Improve-read_stream.c-look-ahead-heuristics-C.txt) at 2025-07-23 01:19:58 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (create-tables.sql) at 2025-07-22 20:50:00 from Tomas Vondra <tomas at vondra.me> (Patch: No)
    Attachment (leafkeyspace.sql) at 2025-07-22 17:50:16 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (pgbench_accounts_pkey_nhblks.txt) at 2025-07-22 17:35:14 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (d16-rows-cold-32GB-16-unscaled-log.pdf) at 2025-07-22 13:06:46 from Tomas Vondra <tomas at vondra.me> (Patch: No)
    Attachment (0001-aio-Refactor-read_stream.c-end-of-stream-state.txt) at 2025-07-21 12:39:48 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (0001-read_stream-restore-prefetch-distance-after-reset.patch) at 2025-07-18 18:31:37 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (d16-rows-cold-32GB-16-unscaled.pdf) at 2025-07-16 08:40:29 from Tomas Vondra <tomas at vondra.me> (Patch: No)
    Attachment (v20250709-0001-index-prefetch-infrastructure.patch) at 2025-07-09 22:55:08 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (v20250501-0001-WIP-index-prefetching.patch) at 2025-05-01 23:02:06 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (v20250422-0001-WIP-index-prefetching.patch) at 2025-04-22 10:45:55 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    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
2025-07-24 11:35:28	CFbot	Patch does not need rebase anymore
2025-07-23 14:56:20	CFbot	Patch needs rebase
2025-04-22 11:01:45	CFbot	Patch does not need rebase anymore
2025-04-02 18:15:42	Tomas Vondra (fuzzycz)	Closed in commitfest 2025-03 with status: Moved to next CF
2025-03-11 04:13:43	vigneshwaran C (vignesh.postgres)	New status: Waiting on Author
2025-02-17 18:26:35	CFbot	Patch needs rebase
2025-02-06 22:06:06	Tomas Vondra (fuzzycz)	Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-01 19:06:13	Dmitry Dolgov (erthalion)	Closed in commitfest 2024-11 with status: Moved to next CF
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