Improve I/O pattern for parallel seqscan

Edit
Title Improve I/O pattern for parallel seqscan
Topic Performance
Created 2020-06-21 23:38:31
Last modified 2020-06-21 23:38:50 (3 weeks, 1 day ago)
Latest email 2020-07-14 07:13:13 (15 hours, 40 minutes ago)
Status
2020-07: Needs review
Target version
Authors David Rowley (davidrowley), Thomas Munro (macdice)
Reviewers Become reviewer
Committer
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-14 07:13:13 by Thomas Munro <thomas.munro 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-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
Edit