UNIX File buffering disable?
От | Oli Sennhauser |
---|---|
Тема | UNIX File buffering disable? |
Дата | |
Msg-id | 3FEC3BF4.9060203@bluewin.ch обсуждение исходный текст |
Ответы |
Re: UNIX File buffering disable?
Re: UNIX File buffering disable? Re: UNIX File buffering disable? |
Список | 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.sennhauser@bluewin.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
Вложения
В списке pgsql-admin по дате отправления: