X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D0429DA9D0 for ; Sat, 22 Oct 2005 18:52:44 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 09359-02 for ; Sat, 22 Oct 2005 21:52:41 +0000 (GMT) Received: from mail21.sea5.speakeasy.net (mail21.sea5.speakeasy.net [69.17.117.23]) by svr1.postgresql.org (Postfix) with ESMTP id CE4A4DA9C1 for ; Sat, 22 Oct 2005 18:52:42 -0300 (ADT) Received: (qmail 17307 invoked from network); 22 Oct 2005 21:52:44 -0000 Received: from dsl017-073-250.chi4.dsl.speakeasy.net (HELO mofo.meme.com) ([69.17.73.250]) (envelope-sender ) by mail21.sea5.speakeasy.net (qmail-ldap-1.03) with SMTP for ; 22 Oct 2005 21:52:44 -0000 Received: from mofo (localhost.localdomain [127.0.0.1]) by mofo.meme.com (Postfix) with ESMTP id ED3CA6E422; Sat, 22 Oct 2005 17:03:03 -0500 (CDT) Date: Sat, 22 Oct 2005 22:03:03 +0000 From: "Karl O. Pinc" Subject: Re: Need help in setting optimal configuration for a huge To: Kishore B Cc: pgsql-performance@postgresql.org References: <42567e060510221415r2516523l4c3f9b42dee91a09@mail.gmail.com> In-Reply-To: <42567e060510221415r2516523l4c3f9b42dee91a09@mail.gmail.com> (from kishorebh@gmail.com on Sat Oct 22 16:15:25 2005) X-Mailer: Balsa 2.3.0 Message-Id: <1130018583l.27845l.10l@mofo> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; DelSp=Yes; Format=Flowed Content-Disposition: inline Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 required=5 tests=[FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200510/307 X-Sequence-Number: 15075 On 10/22/2005 04:15:25 PM, Kishore B wrote: > Can any you please suggest the best configuration to satisfy the above > requirements? You've increased shared memory buffers, told the kernel to allow more shared memory (lots), and otherwise increased the parameters associated with memory? If so you might want to post the relevant configs here. If the basic tuning does not help enough you may want to upgrade to 8.0 as it has significant performance improvements. Karl Free Software: "You don't pay back, you pay forward." -- Robert A. Heinlein