Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_migrator issues - Mailing list pgsql-hackers

From decibel
Subject Re: pg_migrator issues
Date
Msg-id EBEC5DA1-66B0-4447-954D-B7DB590D4208@decibel.org
Whole thread Raw
In response to pg_migrator issues  (Bruce Momjian <bruce@momjian.us>)
Responses Re: pg_migrator issues  (decibel <decibel@decibel.org>)
List pgsql-hackers
Tree view 
On Dec 30, 2009, at 9:50 PM, Bruce Momjian wrote:
> 3)  There is no easy way to analyze all databases.  vacuumdb --analyze
> does analyze _and_ vacuum, which for an 8.4 to 8.5 migration does an
> unnecessary vacuum.  Right now I recommend ANALYZE in every database,
> but it would be nice if there were a single command which did this.

I actually started on a patch for this (http://lnk.nu/archives.postgresql.org/14rm.php). IIRC it's pretty close, I just
haven'thad time to come back to it for final cleanup and changing the docs as needed. 
--
Jim C. Nasby, Database Architect                   jim@nasby.net
512.569.9461 (cell)                         http://jim.nasby.net

pgsql-hackers by date:

Previous
From: decibel
Date:
Subject: Re: Stats for inheritance trees
Next
From: Boszormenyi Zoltan
Date:
Subject: Re: ecpg compile error