Analyze all from command line

Поиск
Список
Период
Сортировка
От Robert James
Тема Analyze all from command line
Дата
Msg-id CAGYyBgi26GaaukLPfrfxGDDekRDgTe=HfVHmrRNAirGtCixhhA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Analyze all from command line  (Adrian Klaver <adrian.klaver@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Is there a way to avoid hard coding database connection info into views?
Следующее
От: Mike Christensen
Дата:
Сообщение: Re: Is there a way to avoid hard coding database connection info into views?