> > I believe there's something similar for OS X as well. The question is: > > would it be better to do that, or to just delay calling fsync until the > > OS has had a chance to write things out. > > A delay is not going to help unless you can suppress additional writes > to the file, which I don't think you can unless there's very little > going on in the database --- dirty buffers have to get written to make > room for other pages, checkpoint in progress or no.
But checkpoint first writes all dirty pages, so we have more than average pages that can be replaced without a write. Thus we have a window where we can wait until dirty pages have to be replaced again. Since the bgwriter is sleeping until fsync, only pages that have to be replaced will be written. Question is, how do we time that window. Andreas ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly