From: | Oli Sennhauser <oli(dot)sennhauser(at)bluewin(dot)ch> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | UNIX File buffering disable? |
Date: | 2003-12-26 13:47:32 |
Message-ID: | 3FEC3BF4.9060203@bluewin.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello
I have heard that UNIX I/O buffer sometimes causes problems during
system crash because it keeps files which, application thinks, are
already written to disk. And then this changes go lost during crash.
Therefore I heard a recommendation, that dba's should disabled UNIX file
buffering on mountpoints where rdbms are running.
What about this? Any hints? What about PostgreSQL? Do we bypass this OS
buffering (fsync?) or should a dba do anything else?
How do I disable this I/O buffering?
Thanks for comments
Oli
-------------------------------------------------------
Oli Sennhauser
Database-Engineer (Oracle & PostgreSQL)
Rebenweg 6
CH - 8610 Uster / Switzerland
Phone (+41) 1 940 24 82 or Mobile (+41) 79 450 49 14
e-Mail oli(dot)sennhauser(at)bluewin(dot)ch
Website http://mypage.bluewin.ch/shinguz/PostgreSQL/
Secure (signed/encrypted) e-Mail with a Free Personal SwissSign ID: http://www.swisssign.ch
Import the SwissSign Root Certificate: http://swisssign.net/cgi-bin/trust/import
From | Date | Subject | |
---|---|---|---|
Next Message | Oli Sennhauser | 2003-12-26 14:39:00 | Re: Opinion wanted: Default select rights for users via public |
Previous Message | Joshua D. Drake | 2003-12-25 00:28:58 | Re: [GENERAL][HACKERS]data fragmentation |