Re: [GENERAL] vacuum analyze works on tables, but not on entire database - Mailing list pgsql-general

From Slavica Stefic
Subject Re: [GENERAL] vacuum analyze works on tables, but not on entire database
Date
Msg-id 99111600263601.01115@slavica
Whole thread Raw
In response to Re: [GENERAL] vacuum analyze works on tables, but not on entire database  ("Aaron J. Seigo" <aaron@gtv.ca>)
List pgsql-general
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
>
> ************

pgsql-general by date:

Previous
From: "Aaron J. Seigo"
Date:
Subject: Re: [GENERAL] RPM vs. tar for 6.5.3
Next
From: "Alain TESIO"
Date:
Subject: Basic question about indexes (6.5.2)