X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 9357BB4388D for ; Wed, 9 Jul 2003 18:29:21 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 18693-07 for ; Wed, 9 Jul 2003 15:29:10 -0300 (ADT) Received: from hot.ee (mail.hot.ee [194.126.101.94]) by svr1.postgresql.org (Postfix) with ESMTP id 30673B430B3 for ; Wed, 9 Jul 2003 15:29:06 -0300 (ADT) Received: from localhost (relay3 [127.0.0.1]) by hot.ee (Postfix) with ESMTP id 82FD0C1110; Wed, 9 Jul 2003 21:29:02 +0300 (EEST) Received: from hot.ee ([127.0.0.1]) by localhost (relay3 [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24055-18; Wed, 9 Jul 2003 21:29:02 +0300 (EEST) Received: from future.ee (80-235-33-206-dsl.mus.estpak.ee [80.235.33.206]) by hot.ee (Postfix) with ESMTP id 2C9EFC1127; Wed, 9 Jul 2003 21:29:00 +0300 (EEST) Message-ID: <3F0C5FFF.30406@future.ee> Date: Wed, 09 Jul 2003 21:33:35 +0300 From: Kaarel User-Agent: Mozilla/5.0 (X11; U; Linux i686; et-EE; rv:1.3) Gecko/20030313 X-Accept-Language: et, en-gb MIME-Version: 1.0 To: Tom Lane Cc: Matthew Nuzum , 'Andrew Sullivan' , pgsql-performance@postgresql.org Subject: Re: Moving postgresql.conf tunables into 2003... References: <008301c34489$4dbf0b00$a322fea9@mattspc> <19041.1057584643@sss.pgh.pa.us> In-Reply-To: <19041.1057584643@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by mail.hot.ee X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/155 X-Sequence-Number: 2448 >>Are you willing to say that the PostgreSQL database system should only be >>used by DBAs? I believe that Postgres is such a good and useful tool that >>anyone should be able to start using it with little or no barrier to entry. > > > I quite agree. But there is a difference between saying "you should get > decent performance with no effort" and "you should get optimal > performance with no effort". I think we can get to the first with > relatively little trouble (like boosting the default shared_buffers to > 1000), but the second is an impractical goal. Just wanted to repeat some of the thoughts already been expressed. There are no reasons why shouldn't PostgreSQL be reasonably well configured for a particular platform out of the box. Not for maximum performance but for good enough performance. The many complaints by new users about PostgreSQL being suprisingly slow and the all the so standard answers (vacuum, pump up memory settings) imho prove that the default installatio can be improved. Already mentioned in the mail lists: using multiple standard conf files, quering system info and dynamically generating all or some parts of the conf file, automating the vacuum process... Kaarel