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. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada <[EMAIL PROTECTED]> M2P 2A8 +1 416 646 3304 x110 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match