"Wes" <[EMAIL PROTECTED]> writes: > I guess I should also turn off fsync for the duration.
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. 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. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
