Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id F22482E3737 for ; Thu, 10 Jan 2008 04:45:32 -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 81497-06 for ; Thu, 10 Jan 2008 04:45:24 -0400 (AST) Received: from cptwks26.careerjunction.local (unknown [196.212.105.173]) by postgresql.org (Postfix) with ESMTP id 911E92E312A for ; Thu, 10 Jan 2008 04:45:25 -0400 (AST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by cptwks26.careerjunction.local (Postfix) with ESMTP id 0DEF4B8180; Thu, 10 Jan 2008 10:45:18 +0200 (SAST) Message-ID: <4785DB1D.6050008@careerjunction.co.za> Date: Thu, 10 Jan 2008 10:45:17 +0200 From: Adrian Moisey User-Agent: Thunderbird 2.0.0.6 (X11/20071022) MIME-Version: 1.0 To: Alan Hodgson CC: pgsql-performance@postgresql.org Subject: Re: big database performance References: <4784835A.8070604@careerjunction.co.za> <47848575.8000007@commandprompt.com> <4784C3B5.9060108@careerjunction.co.za> <200801090816.48859@hal.medialogik.com> In-Reply-To: <200801090816.48859@hal.medialogik.com> 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=BAYES_50=0.001, RDNS_NONE=0.1 X-Spam-Level: X-Archive-Number: 200801/49 X-Sequence-Number: 28288 Hi >> Also, we're running the db on ext3 with noatime. Should I look at >> changing or getting rid of journaling ? > > No (unless you like really long fsck times). data=writeback is safe with > PostgreSQL, though. I tested that on a dev box, and I didn't notice a difference when using pgbench -- 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