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

From: "Doran L(dot) Barton" <fozz(at)iodynamics(dot)com>
To: "Aaron J(dot) Seigo" <aaron(at)gtv(dot)ca>
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:09:06
Message-ID: 19991115140906.C2513@iodynamics.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?
--
Doran L. Barton <fozz(at)iodynamics(dot)com>
Iodynamics LLC -- "Internetworking the masses"
<URL:http://www.iodynamics.com/>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Hyland 1999-11-15 21:19:16 user-defined types question
Previous Message ^chewie 1999-11-15 20:58:22 Re: [GENERAL] RPM vs. tar for 6.5.3