Analyze all from command line

From: Robert James <srobertjames(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Analyze all from command line
Date: 2012-05-15 20:46:38
Message-ID: CAGYyBgi26GaaukLPfrfxGDDekRDgTe=HfVHmrRNAirGtCixhhA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Christensen 2012-05-15 20:50:29 Re: Is there a way to avoid hard coding database connection info into views?
Previous Message Merlin Moncure 2012-05-15 20:44:13 Re: Is there a way to avoid hard coding database connection info into views?