Greg Smith wrote:
> Since your smaller system has 2GB of RAM and the larger one 32GB, try
> this instead:
>
> pgbench -i -s 2000
> pgbench -c 24 -T 60 -S
> pgbench -c 24 -T 300
Oh, and to at least give a somewhat more normal postgresql.conf I'd
recommend you at least make the following two changes before doing the
above:
shared_buffers=256MB
checkpoint_segments=32
Those are the two parameters the pgbench test is most sensitive to, so
setting to higher values will give more realistic results.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us
