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@xxxxxxxxxxxxxxx www.2ndQuadrant.us
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
