UNIX File buffering disable?

Поиск
Список
Период
Сортировка
От Oli Sennhauser
Тема UNIX File buffering disable?
Дата
Msg-id 3FEC3BF4.9060203@bluewin.ch
обсуждение исходный текст
Ответы Re: UNIX File buffering disable?  (Sai Hertz And Control Systems <sank89@sancharnet.in>)
Re: UNIX File buffering disable?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: UNIX File buffering disable?  (Greg Spiegelberg <gspiegelberg@cranel.com>)
Список 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 по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: [GENERAL][HACKERS]data fragmentation
Следующее
От: Oli Sennhauser
Дата:
Сообщение: Re: Opinion wanted: Default select rights for users via public