Re: ANALYZE after restore - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ANALYZE after restore
Date
Msg-id 6520.1017806995@sss.pgh.pa.us
Whole thread Raw
In response to Re: ANALYZE after restore  (Gavin Sherry <swm@linuxworld.com.au>)
List pgsql-hackers
Gavin Sherry <swm@linuxworld.com.au> writes:
> On Wed, 3 Apr 2002, Christopher Kings-Lynne wrote:
>> Would it be an idea to have pg_dump append an ANALYZE; command to the end of
>> its dumps to assist newbies / inexperienced admins?

> I do not think this is desired behaviour.

I agree with Gavin here ... a forced VACUUM or ANALYZE after a restore
will just get in the way of people who know what they're doing, and it's
not at all clear that it will help people who do not.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: SHOW ALL as a query result
Next
From: "Christopher Kings-Lynne"
Date:
Subject: BETWEEN SYMMETRIC/ASYMMETRIC