Re: Please Help: PostgreSQL performance Optimization

On Thu, 12 Jan 2006 01:32:10 +0100
Jamal Ghaffour <Jamal(dot)Ghaffour(at)elios-informatique(dot)fr> wrote:

> I'm using the default configuration file, and i m asking if i have to
> change some paramters to have a good performance.

In general the answer is yes. The default is a pretty good best guess
at what sorts of values work for your "typical system", but if you run
into performance problems the config file is where you should look
first, provided you've done the simple things like adding good
indexes, vacumm analyze, etc.

You'll want to consult the following various documentation out there
to help your properly tune your configuration:

http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
http://www.powerpostgresql.com/Docs
http://www.powerpostgresql.com/PerfList
http://www.revsys.com/writings/postgresql-performance.html

Hopefully these will help you understand how to set your configuration
values.

---------------------------------
Frank Wiles <frank(at)wiles(dot)org>
http://www.wiles.org
---------------------------------