Prefetch the next tuple's memory during seqscans

ID 3978

Title Prefetch the next tuple's memory during seqscans

Topic Performance

Created 2022-10-31 03:53:52

Last modified 2024-01-22 09:51:26 (9 months, 4 weeks ago)

Latest email 2024-01-22 10:15:59 (9 months, 4 weeks ago)

Status

2024-01: Withdrawn

2023-11: Moved to next CF

2023-09: Moved to next CF

2023-07: Moved to next CF

2023-03: Moved to next CF

2023-01: Moved to next CF

2022-11: Moved to next CF

Target version

Authors David Rowley (davidrowley), Thomas Munro (macdice)

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

Emails

Prefetch the next tuple's memory during seqscans: First at 2022-10-31 03:52:52 by David Rowley <dgrowleyml at gmail.com>
Latest at 2024-01-22 10:15:59 by David Rowley <dgrowleyml at gmail.com>
Latest attachment (v2-0001-Add-pg_prefetch_mem-macro-to-load-cache-lines.patch) at 2023-07-10 09:34:38 from Daniel Gustafsson <daniel at yesql.se>
    Attachment (v2-0001-Add-pg_prefetch_mem-macro-to-load-cache-lines.patch) at 2023-07-10 09:34:38 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (v2-0001-Add-pg_prefetch_mem-macro-to-load-cache-lines.patch) at 2023-07-10 09:32:28 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (v1-0001-Add-pg_prefetch_mem-macro-to-load-cache-lines.patch) at 2023-04-04 04:50:09 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (tpch_results.txt) at 2022-11-24 09:25:09 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (v2-0001-Add-pg_prefetch_mem-macro-to-load-cache-lines.patch) at 2022-11-22 21:58:07 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (prefetch-heapgetpage.diff) at 2022-11-02 17:25:44 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (bench_prefetch.sh.txt) at 2022-10-31 22:17:14 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (0001-Add-pg_prefetch_mem-macro-to-load-cache-lines.patch) at 2022-10-31 03:52:52 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)

History

When	Who	What
2024-01-22 09:51:26	David Rowley (davidrowley)	Closed in commitfest 2024-01 with status: Withdrawn
2023-12-04 09:19:30	John Naylor (john.naylor)	Closed in commitfest 2023-11 with status: Moved to next CF
2023-10-02 09:46:11	Peter Eisentraut (petere)	Closed in commitfest 2023-09 with status: Moved to next CF
2023-08-03 08:07:59	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2023-07 with status: Moved to next CF
2023-07-10 09:34:50	Daniel Gustafsson (d_gustafsson)	New status: Needs review
2023-04-09 01:40:04	Greg Stark (stark)	Closed in commitfest 2023-03 with status: Moved to next CF
2023-01-30 02:19:49	David Rowley (davidrowley)	Closed in commitfest 2023-01 with status: Moved to next CF
2023-01-09 02:39:40	vigneshwaran C (vignesh.postgres)	New status: Waiting on Author
2022-12-13 10:57:17	Thomas Munro (macdice)	Closed in commitfest 2022-11 with status: Moved to next CF
2022-10-31 03:54:07	David Rowley (davidrowley)	Changed authors to David Rowley (davidrowley), Thomas Munro (macdice)
2022-10-31 03:53:52	David Rowley (davidrowley)	Attached mail thread CAApHDvpTRx7hqFZGiZJ=d9JN4h1tzJ2=xt7bM-9XRmpVj63psQ@mail.gmail.com
2022-10-31 03:53:52	David Rowley (davidrowley)	Created patch record