From: Heikki Linnakangas <heikki@enterprisedb.com>
To: Bebarta, Simanchala <Simanchala.Bebarta@in.unisys.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Need help on parameters and their values to tune the postgresql database
Date: Fri, 14 Dec 2007 11:03:56 +0000
Message-ID: <4762631C.3050709@enterprisedb.com> (raw)
In-Reply-To: <D566E8CF3538B54D95B925CB69CB4D2A09971CD2@inblr-exch1.eu.uis.unisys.com>
References: <D566E8CF3538B54D95B925CB69CB4D2A09971CD2@inblr-exch1.eu.uis.unisys.com>
Bebarta, Simanchala wrote:
> I am doing a performance benchmarking test by using benchmarkSQL tool on
> postgresql 8.2.4.I need to tune the parameters to achieve an optimal
> performance of the postgresql database.
>
> I have installed postgresql 8.2.4 on RHEL AS4. It is a DELL Optiplex
> GX620 PC with 4GB RAM.
>
> Please suggest me which parameters I need to tune and what would be the
> possible values for the parameters.
>
> Appreciate if I would get a quick response.
Why are you doing the benchmark? That's going to have a big impact on
how you should tune. For example, how much do you value data integrity,
in case of a crash or power outage?
How many warehouses are you planning to use? The fact that you didn't
mention anything about your I/O hardware suggests that you're planning
to do a test that fits entirely in cache. If that's the case, you're
going to be limited by the rate you can fsync the commit WAL records to
disk. If you don't care about data integrity, you can turn fsync=off, to
eliminate that bottleneck. In that case you'll also want to turn
full_page_writes=off; that'll reduce the CPU overhead somewhat.
Another important factor is how long you're going to run the test. If
you run it for more than say 10 minutes, you'll have to run vacuum to
keep the table sizes in check. If it's all in memory, as I presume,
autovacuum might be enough for the task.
PS. You might want to talk to these guys from Unisys:
http://www.pgcon.org/2007/schedule/events/16.en.html
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
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: heikki@enterprisedb.com, Simanchala.Bebarta@in.unisys.com
Subject: Re: Need help on parameters and their values to tune the postgresql database
In-Reply-To: <4762631C.3050709@enterprisedb.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