Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 9F6BE2E3180
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed,  9 Jan 2008 12:14:19 -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 16362-03-3
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed,  9 Jan 2008 12:14:15 -0400 (AST)
Received: from skynet.simkin.ca (skynet.simkin.ca [72.51.27.117])
	by postgresql.org (Postfix) with ESMTP id B26682E2E85
	for <pgsql-performance@postgresql.org>;
	Wed,  9 Jan 2008 12:14:15 -0400 (AST)
Received: from charon.medialogik.com (charon.medialogik.com [72.51.27.114])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by skynet.simkin.ca (Postfix) with ESMTP id 400934C63
	for <pgsql-performance@postgresql.org>;
	Wed,  9 Jan 2008 08:14:14 -0800 (PST)
From: Alan Hodgson <ahodgson@simkin.ca>
Organization: Simkin Network Consulting
To: pgsql-performance@postgresql.org
Subject: Re: big database performance
Date: Wed, 9 Jan 2008 08:16:48 -0800
User-Agent: KMail/1.9.6 (enterprise 0.20070907.709405)
References: <4784835A.8070604@careerjunction.co.za>
	<47848575.8000007@commandprompt.com>
	<4784C3B5.9060108@careerjunction.co.za>
In-Reply-To: <4784C3B5.9060108@careerjunction.co.za>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200801090816.48859@hal.medialogik.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200801/42
X-Sequence-Number: 28281

On Wednesday 09 January 2008, Adrian Moisey <adrian@careerjunction.co.za> 
wrote:
>
> 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.