On Wed, Jan 24, 2018 at 12:06 AM, Mithun Cy <mithun...@enterprisedb.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
