Analyze all from command line - Mailing list pgsql-general

From Robert James
Subject Analyze all from command line
Date
Msg-id CAGYyBgi26GaaukLPfrfxGDDekRDgTe=HfVHmrRNAirGtCixhhA@mail.gmail.com
Whole thread Raw
Responses Re: Analyze all from command line
List 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?

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Is there a way to avoid hard coding database connection info into views?
Next
From: Mike Christensen
Date:
Subject: Re: Is there a way to avoid hard coding database connection info into views?