Re: AW: AW: [HACKERS] WAL does not recover gracefully from out-of -dis k-sp ace

2001-03-09 Thread Tom Lane
"Mikheev, Vadim" <[EMAIL PROTECTED]> writes: > Seems that my Solaris has fdatasync, so I'll test different approaches... A Sun guy told me that Solaris does this just the same way that HPUX does it: fsync() scans all kernel buffers for the file, but O_SYNC doesn't, because it knows it only needs

RE: AW: AW: [HACKERS] WAL does not recover gracefully from out-of-dis k-sp ace

2001-03-09 Thread Mikheev, Vadim
> The reason I'm inclined to question this is that what we want > is not an fsync per write but an fsync per transaction, and we can't > easily buffer all of a transaction's XLOG writes... WAL keeps records in WAL buffers (wal-buffers parameter may be used to increase # of buffers), so we can m

Re: AW: AW: [HACKERS] WAL does not recover gracefully from out-of-dis k-sp ace

2001-03-09 Thread Tom Lane
Zeugswetter Andreas SB <[EMAIL PROTECTED]> writes: > A short test shows, that opening the file O_SYNC, and thus avoiding fsync() > would cut the effective time needed to sync write the xlog more than in half. > Of course we would need to buffer >= 1 xlog page before write (or commit) > to gain th