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

you wrote:
> 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)
similar problem. But I have a table (big: 1.3MB, 7585 rows) on which the vacuum
analyze crash.

I use 6.5.2 also on redhat 5.2

---------
Marko Mikulicic

>
> --
> Aaron J. Seigo
> Sys Admin
>
> ************