Postgres Pro
Downloads
Home   >   mailing lists

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

From Doran L. Barton
Subject Re: [GENERAL] vacuum analyze works on tables, but not on entire database
Date
Msg-id 19991115140906.C2513@iodynamics.com
Whole thread Raw
In response to vacuum analyze works on tables, but not on entire database  ("Aaron J. Seigo" <aaron@gtv.ca>)
Responses Re: [GENERAL] vacuum analyze works on tables, but not on entire database  ("Aaron J. Seigo" <aaron@gtv.ca>)
List pgsql-general
Tree view 
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@iodynamics.com>
Iodynamics LLC -- "Internetworking the masses"
<URL:http://www.iodynamics.com/>

pgsql-general by date:

Previous
From: John Hyland
Date:
Subject: type creation question
Next
From: John Hyland
Date:
Subject: user-defined types question