Le 26/04/2011 18:38, Vick Khera a écrit : > On Tue, Apr 26, 2011 at 11:36 AM, Willy-Bas Loos <willybas@xxxxxxxxx> 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. > That's almost true. If autovacuum is on, it can start an ANALYZE on the big tables. Depends of course on your settings (autovacuum on, stats collector on, etc.) -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
