vacuum analyze works on tables, but not on entire database

Поиск
Список
Период
Сортировка
От Aaron J. Seigo
Тема vacuum analyze works on tables, but not on entire database
Дата
Msg-id 99111511415501.15505@stilborne
обсуждение исходный текст
Ответ на RPM 6.5.3  ("Alain TESIO" <tesio@easynet.fr>)
Ответы Re: [GENERAL] vacuum analyze works on tables, but not on entire database  ("Doran L. Barton" <fozz@iodynamics.com>)
Список pgsql-general
Дерево обсуждения 
hi...

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.

 --
Aaron J. Seigo
Sys Admin

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

Предыдущее
От: Larry Rosenman
Дата:
Сообщение: Re: [GENERAL] [ADMIN] 6.5.3/doesn't recognize localhost in pg_hba.conf (fwd)
Следующее
От: "Bruce Bantos"
Дата:
Сообщение: RPM vs. tar for 6.5.3