Re: analyze after a database restore? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: analyze after a database restore?
Date
Msg-id 200303181705.h2IH58403689@candle.pha.pa.us
Whole thread Raw
In response to Re: analyze after a database restore?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut wrote:
> Bruce Momjian writes:
> 
> > Attached is a committed patch to add a recommendation for ANALYZE after
> > restore.  It is a shame we only have vacuumdb -a to do analyze _and_
> > vacuum, and no analyze-only option.
> 
> Isn't one copy of the text per reference page enough?

Thanks. Fixed.  There were two in pg_dump by accident.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: cursors outside transactions
Next
From: Alvaro Herrera
Date:
Subject: Re: Nested transactions