Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 038E79FB7C9 for ; Wed, 4 Apr 2007 09:32:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 21395-03 for ; Wed, 4 Apr 2007 09:32:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from correio2.docasdoporto.com.br (22.144.199.200.docasdoporto.com.br [200.199.144.22]) by postgresql.org (Postfix) with ESMTP id 1173C9FB813 for ; Wed, 4 Apr 2007 09:32:09 -0300 (ADT) Received: from [201.32.176.97] (account ezequias@fastcon.com.br) by correio2.docasdoporto.com.br (CommuniGate Pro WebUser 4.1.8) with HTTP id 48096307 for pgsql-sql@postgresql.org; Wed, 04 Apr 2007 09:49:52 -0300 From: Subject: Setting high performance on huge server To: pgsql-sql@postgresql.org X-Mailer: CommuniGate Pro WebUser Interface v.4.1.8 Date: Wed, 04 Apr 2007 09:49:52 -0300 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1"; format="flowed" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.321 tagged_above=0 required=5 tests=AWL=-0.455, BAYES_40=-0.185, NO_REAL_NAME=0.961 X-Spam-Level: X-Archive-Number: 200704/53 X-Sequence-Number: 28053 Hi list, Could someone give me a little help with my settings ? How do I increase my performance knowing that my server is a huge server. Here some parameters I suppose are important on this settings: "shared_buffers";"8000kB";"Sets the number of shared memory buffers used by the server." "max_connections";"100";"Sets the maximum number of concurrent connections." "work_mem";"1MB";"Sets the maximum memory to be used for query workspaces." -- Ezequias Rodrigues da Rocha