From: Greg Smith <greg@2ndquadrant.com>
To: Philippe Rimbault <primbault@edd.fr>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance on new 64bit server compared to my 32bit desktop
Date: Thu, 19 Aug 2010 14:31:39 -0400
Message-ID: <4C6D788B.2090308@2ndquadrant.com> (raw)
In-Reply-To: <4C6D76FE.9010407@2ndquadrant.com>
References: <4C6CE64D.6070104@edd.fr>
<4C6D76FE.9010407@2ndquadrant.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: greg@2ndquadrant.com, primbault@edd.fr
Subject: Re: Performance on new 64bit server compared to my 32bit desktop
In-Reply-To: <4C6D788B.2090308@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox