Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B104D650E8A for ; Thu, 3 Jul 2008 20:29:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 38236-02 for ; Thu, 3 Jul 2008 20:29:22 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outbound.icp-qv1-irony-out1.iinet.net.au (outbound.icp-qv1-irony-out1.iinet.net.au [203.59.1.108]) by postgresql.org (Postfix) with ESMTP id 90EFE64FD64 for ; Thu, 3 Jul 2008 20:29:26 -0300 (ADT) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: ApoEADL9bEjLzv55/2dsb2JhbACxfAM X-IronPort-AV: E=Sophos;i="4.30,299,1212336000"; d="scan'208";a="352332116" Received: from unknown (HELO mail) ([203.206.254.121]) by outbound.icp-qv1-irony-out1.iinet.net.au with ESMTP; 04 Jul 2008 07:29:22 +0800 Received: by mail (Postfix, from userid 33) id 32A472D800B; Fri, 4 Jul 2008 09:28:05 +1000 (EST) To: pgsql-admin@postgresql.org Subject: Recourse Usage MIME-Version: 1.0 Date: Fri, 04 Jul 2008 09:28:05 +1000 From: Steve Kecskes X-Priority: 5 (Lowest) Message-ID: X-Sender: steve@outtalimits.com.au User-Agent: RoundCube Webmail/0.1 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/58 X-Sequence-Number: 29668 G'day, I have been tasked to tune our company's Postgres database. From the research I have done I feel the recourse consumption parameters are set far to low. I have come up with the following modifications to the configuration and wanted to run this by the mailing list for any suggestions. The database is on a semi dedicated box, shared only with memcached which has been allocated 512MB. -Dual Xeon 2.33GHz -4GB RAM -Twin SAS drives in RAID 1 Shared Buffers Currently: 8192 pages @ 8 KB each // 64MB To be set to: (256MB - 32768 pages @ 8 KB each) Work Mem Currently: 1024kb To be set to: 1536kb Effective Cache Size Currently: 50000 pages // 390MB To be set to: 128000 pages // 1000MB Random Page Cost Currently: 4.0 To be set to: 3.0 Wal Buffers Currently: 8 @ 8kb each To be set to: 32 @ 8kb each Kind Regards, -- ------------------------------------------------- Steve Kecskes steve@outtalimits.com.au