On 05/15/2012 01:46 PM, Robert James wrote:
I can run clusterdb -a from the command line to cluster all databases. After clustering, its recommended to run ANALYZE. But there doesn't seem to be any way to do this from the command line, and even in SQL, there doesn't seem to be any way to do this for all databases. 1. What's the recommended way to analyze all after doing a clusterdb -a? 2. If I miss a db from analyze, will the cluster still help it?
See here: http://www.postgresql.org/docs/9.1/interactive/app-vacuumdb.html In particular: -a -Z -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
