Re: UNIX File buffering disable?

From: Sai Hertz And Control Systems <sank89(at)sancharnet(dot)in>
To: Oli Sennhauser <oli(dot)sennhauser(at)bluewin(dot)ch>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: UNIX File buffering disable?
Date: 2003-12-26 16:21:46
Message-ID: 3FEC601A.1090904@sancharnet.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello ,

Hmmm
This concernes me to does anyone has answers for this please .
and Oli if you get this answer from some other posts please forward it
here also.

Regards,
Vishal Kashyap

> 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
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-12-26 16:22:36 Re: UNIX File buffering disable?
Previous Message Oli Sennhauser 2003-12-26 14:39:00 Re: Opinion wanted: Default select rights for users via public