Search Postgresql Archives

Re: Analyze all from command line

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux