>>>>> "AS" == Andrew Sullivan <[EMAIL PROTECTED]> writes:
AS> 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"? AS> No; in fact, that's been suggested by many people. I don't know AS> whether anyone's done any tests to prove that it helps. I honestly can't expect it to be much of an improvement since the number of files involved compared with the size of the files is minimal. However, if you're opening/closing the files often it might cause you problems. I think in the normal case where it does matter you have pooled connections so the open/close happens rarely. Of course, if I had a good synthetic workload to pound on my DB, I'd run a test... Sean? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
