Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 9431D2E38B6 for ; Wed, 9 Jan 2008 04:18:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 87342-09 for ; Wed, 9 Jan 2008 04:18:43 -0400 (AST) Received: from cptwks26.careerjunction.local (unknown [196.212.105.173]) by postgresql.org (Postfix) with ESMTP id 20B932E389D for ; Wed, 9 Jan 2008 04:18:47 -0400 (AST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by cptwks26.careerjunction.local (Postfix) with ESMTP id 4ABD1B7A5C for ; Wed, 9 Jan 2008 10:18:35 +0200 (SAST) Message-ID: <4784835A.8070604@careerjunction.co.za> Date: Wed, 09 Jan 2008 10:18:34 +0200 From: Adrian Moisey User-Agent: Thunderbird 2.0.0.6 (X11/20071022) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: big database performance Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.101 tagged_above=0 required=5 tests=AWL=-0.000, BAYES_50=0.001, RDNS_NONE=0.1 X-Spam-Level: X-Archive-Number: 200801/36 X-Sequence-Number: 28275 Hi We recently converted to postgres (from mssql) and we're having performance issues. Not all the issues are related to postgres, but we're trying to sort everything out. The server is running ubuntu Gutsy with the database stored on a IBM SAN. It is a Dell box with dual quad core 2.00GHz Xeons and 8GB RAM. The database is about 71GB in size. I've looked at the postgres config files and we've tweaked as much as our knowledge allows. Can someone shed some light on the settings I should use ? Thanks in advance -- Adrian Moisey System Administrator | CareerJunction | Your Future Starts Here. Web: www.careerjunction.co.za | Email: adrian@careerjunction.co.za Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842