Improve I/O pattern for parallel seqscan

Title

CI (CFBot)

Not processed

Stats (from CFBot)

Unknown

Tags

Performance

Created

2020-06-21 23:38:31

Last modified

2020-07-26 09:10:07 (6 years ago)

Latest email

2020-07-26 09:09:07 (6 years ago)

Status

2020-07 (2020-07-01 – 2020-07-31): Committed

Target version

Authors

David Rowley (davidrowley), Thomas Munro (macdice)

Reviewers

Committer

David Rowley (davidrowley)

Links

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