Re: big database performance - Mailing list pgsql-performance

From Adrian Moisey
Subject Re: big database performance
Date
Msg-id 4785DB1D.6050008@careerjunction.co.za
Whole thread Raw
In response to Re: big database performance  (Alan Hodgson <ahodgson@simkin.ca>)
List 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@careerjunction.co.za
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842

pgsql-performance by date:

Previous
From: Simon Riggs
Date:
Subject: Re: big database performance
Next
From: Adrian Moisey
Date:
Subject: Re: big database performance