Le 26/04/2011 18:38, Vick Khera a écrit :
> On Tue, Apr 26, 2011 at 11:36 AM, Willy-Bas Loos <willybas@gmail.com> 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