>>> On Mon, Dec 11, 2006 at 3:31 PM, in message <[EMAIL PROTECTED]>, Ron Mayer <[EMAIL PROTECTED]> wrote: > > One thing I do worry about is if both postgresql and the OS > are both delaying write()s in the hopes of collapsing them > at the same time. If so, this would cause both to be experience > bigger delays than expected, and make checkpoints worse. That is my concern. Letting 30 seconds worth of dirty pages accumulate between checkpoints and then trying to smooth the writes within checkpoint code seems like a doomed effort. Either we take over control of everything, like many other products, and schedule it all ourselves, or we push it out to the file system fairly quickly and let it do its job. Let's not stand with one foot on the pier and one on the boat. It is entirely possible that the current setup, where a delay of a couple seconds may collapse several OS API calls, could have a performance benefit; but, let's be clear that we're talking about saving that overhead, not disk I/O. -Kevin
---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
