| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | Robert James <srobertjames(at)gmail(dot)com> |
| Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Analyze all from command line |
| Date: | 2012-05-15 20:50:54 |
| Message-ID: | 4FB2C1AE.6050804@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert James | 2012-05-15 20:58:20 | Is there a benefit to CLUSTER when retrieving individual records? |
| Previous Message | Mike Christensen | 2012-05-15 20:50:29 | Re: Is there a way to avoid hard coding database connection info into views? |