On 4 Jan 2016, at 9:24am, Rowan Worth <rowanw at dugeo.com> wrote: > Of course this also mean that VACUUM takes even longer over NFS, so it's > absolutely not worth running before every query. But we've seen benefit > from using VACUUM as a maintenance step while the DBs are not in use.
That is a useful observation. I have seen maintenance routines (some run monthly, some yearly) which include VACUUM as one of the things they do. After taking a backup, of course ! Simon.
