UNIX File buffering disable?

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

Responses

Browse pgsql-admin by date

  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