On 1/25/08 5:40 AM, "Gregory Stark" <stark@xxxxxxxxxxxxxxxx> wrote: > It shouldn't make a big difference. fsync only happens at the end of a > transaction or at a checkpoint. > > Since you're concerned with very long operations the slowdown at the end of > the transaction won't make a big difference. Ok, I didn't realize that. > Checkpoints could be an issue, but you would be better off just raising > checkpoint_segments and/or checkpoint_timeout to make sure you don't get one > more often than once every few minutes when you're doing large operations like > this. I have checkpoint_segments set to 60, and no warnings showing up in the log. Wes ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
