Index Prefetching

Edit

4351

Title

Index Prefetching

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v20250422, Patch count: 3, First patch: +1872−39, All patches: +4395−192

Topic

Performance

Tags

Created

2023-06-08 15:40:45

Last modified

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

Latest email

2025-05-01 23:02:06 (1 month 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-05-01 23:02:06 by Tomas Vondra <tomas at vondra.me>
Latest attachment (v20250501-0001-WIP-index-prefetching.patch) at 2025-05-01 23:02:06 from Tomas Vondra <tomas at vondra.me>
    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-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