X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7EA47528B8 for ; Sat, 2 Jul 2005 09:02:07 -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 97655-05 for ; Sat, 2 Jul 2005 12:01:58 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.197]) by svr1.postgresql.org (Postfix) with ESMTP id 853E452802 for ; Sat, 2 Jul 2005 09:01:57 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 8so241329nzo for ; Sat, 02 Jul 2005 05:01:58 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=ZyhaoZtr10RSl+RDlEcQjihXlQokNNRcC5rskPKjTMfMzsdiFDjZEmLfwxOeVcMJ9fTNs5JvZmw1nHtB/k94cfzJmRNtFe2W6Q8kPNB7pIt2bXbKnysrJNbqMU0mm+9EL/8tF+HnuWRhP6DYsomMz0aXfy9AcKjE8VLna3177/8= Received: by 10.36.222.38 with SMTP id u38mr1090681nzg; Sat, 02 Jul 2005 05:01:58 -0700 (PDT) Received: by 10.36.66.3 with HTTP; Sat, 2 Jul 2005 05:01:58 -0700 (PDT) Message-ID: <42567e0605070205019007657@mail.gmail.com> Date: Sat, 2 Jul 2005 17:31:58 +0530 From: Kishore B Reply-To: Kishore B To: "pgsql-admin@postgresql.org" Subject: Help needed to set the Optimal Value for shared_buffers. Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.494 tagged_above=0 required=5 tests=RCVD_BY_IP, TO_ADDRESS_EQ_REAL X-Spam-Level: X-Archive-Number: 200507/8 X-Sequence-Number: 18064 Hi,=20 I have a couple of issues. =20 One is regarding a file called 'fsync' and the other is related to the sharedBuffers issue. 1) I am new to administering postgresql. When I was wandering through the configuration files for the PostgreSQL, I observed the 'fsync' file. This file is almost identical to the postgresql.conf file, but with differing values for parameters and some new / deleted parameters when compared with the postgresql.conf file. What is the file for? Does it have any specific importance to be taken care of? 2) What is the optimall value for shared_buffers parameter to be set for a huge database that contains a table with upto '4GB' data. We have a dedicated server with 2GB RAM. The maximum connections that can be made to the server is around 500. I found a lot of variation between opinions of different people on this value. I also observed that the said optimal values vary greatly with the version. For PostgreSQL7.X, some suggested an optimal value of 32MB RAM and for PostgreSQL8.0 some suggested a range of 32MB - 480MB. We are using PostgreSQL7.x. Any help will be highly appreciated.=20 Regards,=20 Kishore.