Re: [GENERAL] vacuum analyze works on tables, but not on entire database

Поиск
Список
Период
Сортировка
От Doran L. Barton
Тема Re: [GENERAL] vacuum analyze works on tables, but not on entire database
Дата
Msg-id 19991115140906.C2513@iodynamics.com
обсуждение исходный текст
Ответ на vacuum analyze works on tables, but not on entire database  ("Aaron J. Seigo" <aaron@gtv.ca>)
Ответы Re: [GENERAL] vacuum analyze works on tables, but not on entire database  ("Aaron J. Seigo" <aaron@gtv.ca>)
Список pgsql-general
Not long ago, Aaron J. Seigo proclaimed...
> something bizarre (at least to my experience) has started occuring in our
> production database:
>
> i can run vacuum analyze on each and every table INDIVIDUALLY no problem.. but
> when i vacume analyze the whole db (by going into psql and uttering 'vacuum
> analyze;') it dies.
>
> any thoughts?
>
> its not a huge problem, except that vacuum anlyzing each of the 40 tables is a
> little cumbersome.

Would you care to mutter something about the PG version you're running and
the platform and OS on which you're operating?
--
Doran L. Barton <fozz@iodynamics.com>
Iodynamics LLC -- "Internetworking the masses"
<URL:http://www.iodynamics.com/>

В списке pgsql-general по дате отправления:

Предыдущее
От: John Hyland
Дата:
Сообщение: type creation question
Следующее
От: John Hyland
Дата:
Сообщение: user-defined types question