Re: [HACKERS] fsync and hardware write cache

2004-08-23 Thread Steve Atkins
On Mon, Aug 23, 2004 at 10:19:20PM +0200, Manfred Spraul wrote: > >Does it make sense to add a platform specific call that will flush a write > >cache when fsync is enable? > > > Pete Zaitsev from mysql wrote that there is a special call on Mac OS: > Quoting him: > > >Mac OS X also has this "opti

Re: [HACKERS] fsync and hardware write cache

2004-08-23 Thread Manfred Spraul
[EMAIL PROTECTED] wrote: Something to think about: if you run PostgreSQL with fsync on, but you use the hardware write cache on your disk drives, how likely are you to lose data? Obviously, this is a fairly limited problem, as it only applies to power down (which you can control) or power loss wher

Re: [HACKERS] fsync and hardware write cache

2004-08-23 Thread Bruce Momjian
[EMAIL PROTECTED] wrote: > Something to think about: > > if you run PostgreSQL with fsync on, but you use the hardware write cache > on your disk drives, how likely are you to lose data? Obviously, this is a > fairly limited problem, as it only applies to power down (which you can > control) or po

Re: [HACKERS] fsync and hardware write cache

2004-08-23 Thread Doug McNaught
[EMAIL PROTECTED] writes: > Something to think about: > > if you run PostgreSQL with fsync on, but you use the hardware write cache > on your disk drives, how likely are you to lose data? Obviously, this is a > fairly limited problem, as it only applies to power down (which you can > control) or p

[HACKERS] fsync and hardware write cache

2004-08-23 Thread pgsql
Something to think about: if you run PostgreSQL with fsync on, but you use the hardware write cache on your disk drives, how likely are you to lose data? Obviously, this is a fairly limited problem, as it only applies to power down (which you can control) or power loss where the risks may be reduc