Postgres Pro
Downloads
Home   >   mailing lists

vacuum analyze works on tables, but not on entire database - Mailing list pgsql-general

From Aaron J. Seigo
Subject vacuum analyze works on tables, but not on entire database
Date
Msg-id 99111511415501.15505@stilborne
Whole thread Raw
In response to RPM 6.5.3  ("Alain TESIO" <tesio@easynet.fr>)
Responses Re: [GENERAL] vacuum analyze works on tables, but not on entire database  ("Doran L. Barton" <fozz@iodynamics.com>)
List pgsql-general
Tree view 
hi...

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.

 --
Aaron J. Seigo
Sys Admin

pgsql-general by date:

Previous
From: Larry Rosenman
Date:
Subject: Re: [GENERAL] [ADMIN] 6.5.3/doesn't recognize localhost in pg_hba.conf (fwd)
Next
From: "Bruce Bantos"
Date:
Subject: RPM vs. tar for 6.5.3