From: Adrian Moisey <adrian@careerjunction.co.za>
To: Alan Hodgson <ahodgson@simkin.ca>
Cc: pgsql-performance@postgresql.org
Subject: Re: big database performance
Date: Thu, 10 Jan 2008 10:45:17 +0200
Message-ID: <4785DB1D.6050008@careerjunction.co.za> (raw)
In-Reply-To: <200801090816.48859@hal.medialogik.com>
References: <4784835A.8070604@careerjunction.co.za>
<47848575.8000007@commandprompt.com>
<4784C3B5.9060108@careerjunction.co.za>
<200801090816.48859@hal.medialogik.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: adrian@careerjunction.co.za, ahodgson@simkin.ca
Subject: Re: big database performance
In-Reply-To: <4785DB1D.6050008@careerjunction.co.za>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox