On Wed, 23 Nov 2022 at 20:29, sirisha chamarthi <sirichamarth...@gmail.com> wrote: > I ran your test1 exactly like your setup except the row count is 3000000 > (with 13275 blocks). Shared_buffers is 128MB and the hardware configuration > details at the bottom of the mail. It appears Master + 0001 + 0005 regressed > compared to master slightly .
Thank you for running these tests. Can you share if the plans used for these queries was a parallel plan? I had set max_parallel_workers_per_gather to 0 to remove the additional variability from parallel query. Also, 13275 blocks is 104MBs, does EXPLAIN (ANALYZE, BUFFERS) indicate that all pages were in shared buffers? I used pg_prewarm() to ensure they were so that the runs were consistent. David