On 7 Jan 2010, at 22:26, Roger Binns wrote: > Doing compaction on the 21GB database took about 24 hours. Doing it on the > 3.8 gb database took about 30 mins and probably way less. The machine has > 6GB ram. (It also doesn't help that compaction does frequent fsync's - they > really are not needed.)
It helps in case of a server failure. Compaction can start where it left of after a restart. I don't know the exact frequency, I just go on assuming it is the same 1s we have for delayed_commits. In case of compaction we could probably do them less frequent. Cheers Jan --