Re: increase performancr with "noatime"?

Andrew Sullivan wrote:
> On Tue, Sep 09, 2003 at 04:12:48PM +0800, JM wrote:
>
>>would it cause problem in postgres DB if /var/lib/psql partition is mounted
>>with "noatime"?
>
>
> No; in fact, that's been suggested by many people. I don't know
> whether anyone's done any tests to prove that it helps.

http://www.potentialtech.com/wmoran/postgresql.php#results

You can see, from my _limited_ testing, that it doesn't seem to help enough
to be worth worrying about. In this test, it actually seems to hurt
performance. Read the whole page, though. These tests are heavy on the
writing, it's quite possible that it could improve things if your database
is a heavy read scenerio.

--
Bill Moran
Potential Technologies
http://www.potentialtech.com