Improve I/O pattern for parallel seqscan

Title

Topic

Performance

Created

2020-06-21 23:38:31

Last modified

2020-07-26 09:10:07 (4 years, 3 months ago)

Latest email

2020-07-26 09:09:07 (4 years, 3 months ago)

Status

2020-07: Committed

Target version

Authors

David Rowley (davidrowley), Thomas Munro (macdice)

Reviewers

Committer

David Rowley (davidrowley)

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

Emails

Parallel Seq Scan vs kernel read ahead: First at 2020-05-20 01:53:24 by Thomas Munro <thomas.munro at gmail.com>
Latest at 2020-07-26 09:09:07 by David Rowley <dgrowleyml at gmail.com>
Latest attachment (800gb_table_synchronize_seqscans_test.txt) at 2020-06-24 03:52:46 from David Rowley <dgrowleyml at gmail.com>
    Attachment (800gb_table_synchronize_seqscans_test.txt) at 2020-06-24 03:52:46 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (function.c) at 2020-06-22 20:27:46 from Ranier Vilela <ranier.vf at gmail.com> (Patch: No)
    Attachment (v2_patch_mbsec.png) at 2020-06-22 04:54:22 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (bigger_io_chunks_for_parallel_seqscan_v2.patch) at 2020-06-19 02:10:17 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (table_block_parallelscan_nextpage.sql) at 2020-06-18 10:15:00 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (parallel_batch_size.png) at 2020-06-11 01:47:49 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (0001-Use-larger-step-sizes-for-Parallel-Seq-Scan.patch) at 2020-05-20 01:53:24 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)

History

When	Who	What
2020-07-26 09:10:07	David Rowley (davidrowley)	Closed in commitfest 2020-07 with status: Committed
2020-07-26 09:09:56	David Rowley (davidrowley)	Added davidrowley as committer
2020-06-21 23:38:50	David Rowley (davidrowley)	Changed authors to David Rowley (davidrowley), Thomas Munro (macdice)
2020-06-21 23:38:31	David Rowley (davidrowley)	Attached mail thread CA+hUKGJ_EErDv41YycXcbMbCBkztA34+z1ts9VQH+ACRuvpxig@mail.gmail.com
2020-06-21 23:38:31	David Rowley (davidrowley)	Created patch record