Re: [GENERAL] vacuum analyze works on tables, but not on entire database - Mailing list 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