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
Le 26/04/2011 18:38, Vick Khera a écrit :
> 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.
>
That's almost tr
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.
Hi,
i've tested on 8.3 and 8.4 and i found that autovacuum works during restore
uin my test scenario, which is:
a new database wit two tables. tab1 has 1M recs, tab2 has 10 recs.
When i drop the database and restore, pg_stat_all tables tells me good
estimations for the number of live tuples.
But
