Re: [ADMIN] [GENERAL]auto vacuum during restore

2011-04-26 Thread Vick Khera
On Tue, Apr 26, 2011 at 11:36 AM, Willy-Bas Loos wrote: > I don't get it, they should have been analyzed at restore, should they not? > I do not believe analyze is part of the restore process. You must explicitly run it.

Re: [ADMIN] [GENERAL]auto vacuum during restore

2011-04-26 Thread Vick Khera
On Tue, Apr 26, 2011 at 12:59 PM, Guillaume Lelarge wrote: > > I do not believe analyze is part of the restore process. You must > > explicitly run it. > > > > That's almost true. If autovacuum is on, it can start an ANALYZE on the > big tables. > > So that just means you need some luck of timing