| From: | Slavica Stefic <izvori(at)iname(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 23:16:26 |
| Message-ID: | 99111600263601.01115@slavica |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
you wrote:
> 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)
similar problem. But I have a table (big: 1.3MB, 7585 rows) on which the vacuum
analyze crash.
I use 6.5.2 also on redhat 5.2
---------
Marko Mikulicic
>
> --
> Aaron J. Seigo
> Sys Admin
>
> ************
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alain TESIO | 1999-11-16 00:16:32 | Basic question about indexes (6.5.2) |
| Previous Message | Aaron J. Seigo | 1999-11-15 21:58:40 | Re: [GENERAL] RPM vs. tar for 6.5.3 |