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

Поиск
Список
Период
Сортировка
От Aaron J. Seigo
Тема Re: [GENERAL] vacuum analyze works on tables, but not on entire database
Дата
Msg-id 99111514415202.15505@stilborne
обсуждение исходный текст
Ответ на Re: [GENERAL] vacuum analyze works on tables, but not on entire database  ("Doran L. Barton" <fozz@iodynamics.com>)
Список pgsql-general
On Mon, 15 Nov 1999, Doran L. Barton wrote:
> 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?

oops =)

PGSQL: 6.5.1
OS: Linux (Redhat 5.2)

--
Aaron J. Seigo
Sys Admin

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

Предыдущее
От: John Hyland
Дата:
Сообщение: user-defined types question
Следующее
От: "Aaron J. Seigo"
Дата:
Сообщение: Re: [GENERAL] RPM vs. tar for 6.5.3