Jim C. Nasby wrote: > On Thu, Dec 28, 2006 at 12:50:19PM -0500, Bruce Momjian wrote: > > To summarize, if we could have fsync() only write the dirty buffers that > > happened as part of the checkpoint, we could delay the write() for the > > entire time between checkpoints, but we can't do that, so we have to > > make it user-tunable. > > What about the mmap/msync(?)/munmap idea someone mentioned?
I see that as similar to using O_DIRECT during checkpoint, which had poor performance. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq