| From: | decibel <decibel(at)decibel(dot)org> |
|---|---|
| To: | decibel <decibel(at)decibel(dot)org> |
| Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | Re: pg_migrator issues |
| Date: | 2010-01-06 08:10:26 |
| Message-ID: | 1CB980B6-2EB3-49BB-A1D4-975743833495@decibel.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Jan 6, 2010, at 1:52 AM, decibel wrote:
> 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't had time to come back to it for final cleanup and changing the docs as needed.
Crap, I see I should have read the whole thread before posting. Sorry for the noise (and not getting the patch completed). :(
--
Jim C. Nasby, Database Architect jim(at)nasby(dot)net
512.569.9461 (cell) http://jim.nasby.net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Boszormenyi Zoltan | 2010-01-06 08:11:39 | Re: ecpg compile error |
| Previous Message | Heikki Linnakangas | 2010-01-06 08:03:58 | Re: Streaming replication and postmaster signaling |