Neil Conway wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Another idea --- if fsync() is slow because it can't find the dirty > > buffers, use write() to write the buffers, copy the buffer to local > > memory, mark it as clean, then open the file with O_SYNC and write > > it again. > > Yuck.
This idea if mine will not even work unless others are prevented from writing that data block while I am fsync'ing from local memory --- what if someone modified and wrote that block before my block did its fsync write? I would overwrite their new data. It was just a crazy idea. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
