Re: big database performance

From: Adrian Moisey <adrian(at)careerjunction(dot)co(dot)za>
To: Alan Hodgson <ahodgson(at)simkin(dot)ca>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: big database performance
Date: 2008-01-10 08:45:17
Message-ID: 4785DB1D.6050008@careerjunction.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)careerjunction(dot)co(dot)za
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Adrian Moisey 2008-01-10 08:57:46 Re: big database performance
Previous Message Simon Riggs 2008-01-09 21:01:18 Re: big database performance