Re: Analyze all from command line

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@gmail.com