X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 7A7F99DD737 for ; Fri, 13 Jan 2006 13:41:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 52362-03 for ; Fri, 13 Jan 2006 13:41:00 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from frank.wiles.org (frank.wiles.org [24.124.39.75]) by postgresql.org (Postfix) with ESMTP id A38EE9DCC30 for ; Fri, 13 Jan 2006 13:40:57 -0400 (AST) Received: from kungfu (frank.wiles.org [127.0.0.1]) by frank.wiles.org (8.13.1/8.13.1) with SMTP id k0DHeowg001745; Fri, 13 Jan 2006 11:40:50 -0600 Date: Fri, 13 Jan 2006 11:41:26 -0600 From: Frank Wiles To: Jamal Ghaffour Cc: pgsql-performance@postgresql.org Subject: Re: Please Help: PostgreSQL performance Optimization Message-Id: <20060113114126.747383fb.frank@wiles.org> In-Reply-To: <43C5A38A.8090208@elios-informatique.fr> References: <43C5A38A.8090208@elios-informatique.fr> X-Mailer: Sylpheed version 2.0.1 (GTK+ 2.6.10; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.051 required=5 tests=[AWL=0.051] X-Spam-Score: 0.051 X-Spam-Level: X-Archive-Number: 200601/165 X-Sequence-Number: 16643 On Thu, 12 Jan 2006 01:32:10 +0100 Jamal Ghaffour 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 http://www.wiles.org ---------------------------------