From: | Vick Khera <vivek(at)khera(dot)org> |
---|---|
To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
Cc: | pgsql-general(at)postgresql(dot)org, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: [GENERAL]auto vacuum during restore |
Date: | 2011-04-26 17:07:31 |
Message-ID: | BANLkTimW+HZcDUf4W2J0HYp_o3Jy=q0iRw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
On Tue, Apr 26, 2011 at 12:59 PM, Guillaume Lelarge
<guillaume(at)lelarge(dot)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.)
>
From | Date | Subject | |
---|---|---|---|
Next Message | Fred Parkinson | 2011-04-26 19:21:06 | pgadmin3 install fails |
Previous Message | Guillaume Lelarge | 2011-04-26 16:59:01 | Re: [GENERAL]auto vacuum during restore |
From | Date | Subject | |
---|---|---|---|
Next Message | Phoenix Kiula | 2011-04-26 17:11:00 | PG 9.0 - Default postgresql.conf? |
Previous Message | Guillaume Lelarge | 2011-04-26 16:59:01 | Re: [GENERAL]auto vacuum during restore |