vacuum analyze works on tables, but not on entire database

From: "Aaron J(dot) Seigo" <aaron(at)gtv(dot)ca>
To: pgsql-general(at)postgreSQL(dot)org
Subject: vacuum analyze works on tables, but not on entire database
Date: 1999-11-15 18:38:19
Message-ID: 99111511415501.15505@stilborne
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

  • RPM 6.5.3 at 1999-11-14 23:08:29 from Alain TESIO

Responses

Browse pgsql-general by date

  From Date Subject
Next Message The Hermit Hacker 1999-11-15 19:26:56 Re: [HACKERS] Looks like hell, but ...
Previous Message Brian Hirt 1999-11-15 18:14:26 Re: [HACKERS] Looks like hell, but ...