Hi,
shared_buffers = '128MB'
track_io_timing = on
jit = off
effective_io_concurrency = 500
log_min_messages = warning
max_parallel_workers_per_gather = 0
io_combine_limit = ${IO_COMBINE_LIMIT:-36}
NROWS="${NROWS:-20000000}"
shared_buffers = '64GB'
track_io_timing = on
jit = off
effective_io_concurrency = 500
log_min_messages = warning
max_parallel_workers_per_gather = 0
io_combine_limit = ${IO_COMBINE_LIMIT:-36}
NROWS="${NROWS:-200000000}"
With these settings, running the benchmark script on a larger machine
(AX162-R from hetzner) installed with NVMe SSDs did not reveal
consistent or obvious performance gains or regressions in the patched
version, although it did show slightly better results for bitmap scans
in some runs.
Best,
Xuneng