Index Insert Prefetching

Title

Topic

Performance

Created

2023-10-22 18:22:44

Last modified

2024-06-21 16:13:10 (4 months, 4 weeks ago)

Latest email

2024-01-26 14:45:52 (9 months, 3 weeks ago)

Status

2024-07: Withdrawn

2024-03: Moved to next CF

2024-01: Moved to next CF

2023-11: Moved to next CF

Target version

Authors

Tomas Vondra (fuzzycz)

Reviewers

Committer

Links

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/4622
git checkout commitfest/cf/4622

Emails

PoC: prefetching index leaf pages (for inserts): First at 2023-10-22 14:46:51 by Tomas Vondra <tomas.vondra at enterprisedb.com>
Latest at 2024-01-26 14:45:52 by vignesh C <vignesh21 at gmail.com>
Latest attachment (0001-insert-prefetch-v3.patch) at 2023-11-06 17:05:56 from Tomas Vondra <tomas.vondra at enterprisedb.com>
    Attachment (0001-insert-prefetch-v3.patch) at 2023-11-06 17:05:56 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (prefetch-benchmark.pdf) at 2023-11-01 14:10:03 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: No)
    Attachment (index-insert-prefetch-20231022.patch) at 2023-10-22 14:46:51 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)

History

When	Who	What
2024-06-21 16:13:10	Tomas Vondra (fuzzycz)	Closed in commitfest 2024-07 with status: Withdrawn
2024-04-08 07:25:32	Andrey Borodin (x4m)	Closed in commitfest 2024-03 with status: Moved to next CF
2024-02-01 18:55:24	vigneshwaran C (vignesh.postgres)	Closed in commitfest 2024-01 with status: Moved to next CF
2024-01-30 10:53:12	vigneshwaran C (vignesh.postgres)	New status: Waiting on Author
2023-12-04 09:54:18	John Naylor (john.naylor)	Closed in commitfest 2023-11 with status: Moved to next CF
2023-11-02 05:57:50	John Naylor (john.naylor)	Changed authors to Tomas Vondra (fuzzycz)
2023-10-22 18:22:44	Tomas Vondra (fuzzycz)	Attached mail thread 8081aa62-4032-927c-8411-548e1b87ed5b@enterprisedb.com
2023-10-22 18:22:44	Tomas Vondra (fuzzycz)	Created patch record