Re: Possible performance regression in version 10.1 with pgbench read-write tests.

On Wed, Jan 24, 2018 at 12:06 AM, Mithun Cy <mithun(dot)cy(at)enterprisedb(dot)com> wrote:
> Hi all,
>
> When I was trying to do read-write pgbench bench-marking of PostgreSQL
> 9.6.6 vs 10.1 I found PostgreSQL 10.1 regresses against 9.6.6 in some
> cases.
>
> Non Default settings and test
> ======================
> Server:
> ./postgres -c shared_buffers=8GB -N 200 -c min_wal_size=15GB -c
> max_wal_size=20GB -c checkpoint_timeout=900 -c
> maintenance_work_mem=1GB -c checkpoint_completion_target=0.9 &
>
> Pgbench:
> CASE 1: when data fits shared buffers.
> ./pgbench -i -s 1000 postgres
>
> CASE 2: when data exceeds shared buffers.
> ./pgbench -i -s 1000 postgres
>

Both the cases look identical, but from the document attached, it
seems the case-1 is for scale factor 300.

--
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com