> My plan is to create another background process very similar to > the checkpointer and to let that run forever basically looping over that > BufferSync() with a bool telling that it's the bg_writer.
Why not use the checkpointer itself inbetween checkpoints ? use a min and a max dirty setting like Informix. Start writing when more than max are dirty stop when at min. This avoids writing single pages (which is slow, since it cannot be grouped together by the OS). Andreas ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
