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

From: "Aaron J(dot) Seigo" <aaron(at)gtv(dot)ca>
To: "Doran L(dot) Barton" <fozz(at)iodynamics(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] vacuum analyze works on tables, but not on entire database
Date: 1999-11-15 21:27:48
Message-ID: 99111514415202.15505@stilborne
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Aaron J. Seigo 1999-11-15 21:58:40 Re: [GENERAL] RPM vs. tar for 6.5.3
Previous Message John Hyland 1999-11-15 21:19:16 user-defined types question