Simon Riggs wrote:
So, although its a knife edge decision, I'd say go withsynchronous_commit = off.
I agree - I'm not entirely sure why but it just feels more natural than asynchronous_commit = on. Plus the reasons you give seem valid.
Regards, Dave ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings