> Consider either a box with many different postgresql instances, or one > that run both postgresql and other software. Issuing sync() in that > sitaution will cause sync of a lot of data that probably doesn't need > syncing. > But it'd probably be a very good thing on a dedicated server, giving the > kernel the chance to optimise.
It is not like the sync is done every few seconds ! It is currently done every 5 minutes (I actually think this is too frequent now that we have bgwriter, 10 - 20 min would be sufficient). So imho even on a heavily otherwise used system the sync will be better. Andreas ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]