Postgres Pro
Downloads
Home   >   mailing lists

ANALYZE after restore - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject ANALYZE after restore
Date
Msg-id GNELIHDDFBOCMGBFGEFOOEOPCBAA.chriskl@familyhealth.com.au
Whole thread Raw
Responses Re: ANALYZE after restore  (Neil Conway <nconway@klamath.dyndns.org>)
Re: ANALYZE after restore  (Gavin Sherry <swm@linuxworld.com.au>)
List pgsql-hackers
Tree view 
Hi,

Would it be an idea to have pg_dump append an ANALYZE; command to the end of
its dumps to assist newbies / inexperienced admins?

Reason being is that I noticed that when I just restored a 50MB dump that
the pg_statistic table had no contents...

I think it'd be an idea...

Chris

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Suggestions please: names for function cachability
Next
From: Gavin Sherry
Date:
Subject: Re: Suggestions please: names for function cachability