Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id E43829FA2A7 for ; Tue, 2 Oct 2007 14:48:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 83561-09 for ; Tue, 2 Oct 2007 14:47:51 -0300 (ADT) X-Greylist: delayed 00:18:13.512069 by SQLgrey-1.7.5 Received: from mail3.sqlfusion.com (mail3.sqlfusion.com [168.75.211.46]) by postgresql.org (Postfix) with ESMTP id A57909F9C02 for ; Tue, 2 Oct 2007 14:47:54 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail3.sqlfusion.com (Postfix) with ESMTP id 0776490D098 for ; Tue, 2 Oct 2007 11:34:12 -0700 (PDT) Received: from mail3.sqlfusion.com ([127.0.0.1]) by localhost (mail3.sqlfusion.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27205-06 for ; Tue, 2 Oct 2007 11:34:09 -0700 (PDT) Received: from rajkumarv-arctern.local (unknown [122.167.201.244]) by mail3.sqlfusion.com (Postfix) with ESMTP id E01DA90D097 for ; Tue, 2 Oct 2007 11:34:08 -0700 (PDT) From: Rajakumar Organization: Sqlfusion To: pgsql-admin@postgresql.org Subject: Best Cofniguration Date: Tue, 2 Oct 2007 22:59:32 +0530 User-Agent: KMail/1.9.6 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200710022259.32150.rajkumar@sqlfusion.com> X-DSPAM-Result: Innocent X-DSPAM-Processed: Tue Oct 2 11:34:09 2007 X-DSPAM-Confidence: 0.7785 X-DSPAM-Probability: 0.0000 X-DSPAM-Signature: 47028f21317531944810545 X-DSPAM-Factors: 27, X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200710/5 X-Sequence-Number: 26919 Hi, I have debian server with 15GB mem 182 GB for data 72 GB for WAL 36 GB for backup could you tell update me for a best configuration (postgresql.conf). I have do use maximum resource for the database that only for database. Regards Rajakumar SqlFusion Inc