Prefetch the next tuple's memory during seqscans

Title

Topic

Performance

Created

2022-10-31 03:53:52

Last modified

2023-08-03 08:07:59 (1 month, 3 weeks ago)

Latest email

2023-07-10 09:34:38 (2 months, 2 weeks ago)

Status

2023-09: Needs review

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

Committer

Links

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 2023-07-10 09:34:38 by Daniel Gustafsson <daniel at yesql.se>
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
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