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
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
