Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL]auto vacuum during restore - Mailing list pgsql-admin

From Vick Khera
Subject Re: [GENERAL]auto vacuum during restore
Date
Msg-id BANLkTimW+HZcDUf4W2J0HYp_o3Jy=q0iRw@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL]auto vacuum during restore  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-admin
Tree view
On Tue, Apr 26, 2011 at 12:59 PM, Guillaume Lelarge <guillaume@lelarge.info> 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.  Not really "part of the process" if you ask me.
 


Depends of course on your settings (autovacuum on, stats collector on, etc.)


pgsql-admin by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: [GENERAL]auto vacuum during restore
Next
From: "Fred Parkinson"
Date:
Subject: pgadmin3 install fails