decibel wrote:
One of the talks at PGCon (update in place?) recommended running
vacuumdb -z to analyze all tables to rebuild statistics. Problem with
that is it also vacuums everything. ISTM it'd be useful to be able to
just vacuum all databases in a cluster, so I hacked it into
On Thu, Feb 25, 2010 at 5:09 PM, Bruce Momjian br...@momjian.us wrote:
This is implemented in 9.0 from vacuumdb:
-Z, --analyze-only only update optimizer hints
maybe just noise, but it's not better to say optimizer statistics
instead of optimizer hints?
--
Jaime Casanova wrote:
On Thu, Feb 25, 2010 at 5:09 PM, Bruce Momjian br...@momjian.us wrote:
This is implemented in 9.0 from vacuumdb:
? ? ? ? ?-Z, --analyze-only ? ? ? ? ? ? ?only update optimizer hints
maybe just noise, but it's not better to say optimizer statistics
instead of
Robert Haas wrote:
I noticed in Bruce's talk that there are a number of post-migration
steps which are currently partially manual. Ideally we'd like to
automate them all, preferably in some sort of well-thought-out order.
I actually suspect this is something like: analyze each database,
On May 27, 2009, at 11:31 AM, decibel wrote:
It does seem somewhat useful to be able to analyze all databases
easily from the command-line, but putting it into vacuumdb is
certainly a hack.
So... do we want a completely separate analyzedb command? That
seems like far overkill.
Arguably there
Robert Haas robertmh...@gmail.com wrote:
I noticed in Bruce's talk that there are a number of post-migration
steps which are currently partially manual. Ideally we'd like to
automate them all, preferably in some sort of well-thought-out
order.
I actually suspect this is something like:
On May 23, 2009, at 9:51 PM, Robert Haas wrote:
vacuums everything. ISTM it'd be useful to be able to just vacuum all
databases in a cluster, so I hacked it into vacuumdb.
I think you meant ISTM it'd be useful to be able to just analyze all
databases in a cluster.
Heh. Oops.
Of course,
One of the talks at PGCon (update in place?) recommended running
vacuumdb -z to analyze all tables to rebuild statistics. Problem with
that is it also vacuums everything. ISTM it'd be useful to be able to
just vacuum all databases in a cluster, so I hacked it into vacuumdb.
Of course,
On Sat, May 23, 2009 at 10:31 PM, decibel deci...@decibel.org wrote:
One of the talks at PGCon (update in place?) recommended running vacuumdb -z
to analyze all tables to rebuild statistics. Problem with that is it also
vacuums everything. ISTM it'd be useful to be able to just vacuum all