Rigmor Ukuhe wrote:
> I have table with size ~35 MB, it has several indexes and couple of them are
> well over 500 MB in size (they are indexes with 3-4 columns involved, with
> datatypes like varchar, int4 , timestamp, boolean).
> Database is VACUUMed nightly, version is 7.2.4 (cant upgrade to newest
> version at the moment). Are these
> index sizes indicating some problems with our Postgres server?
If you do not vacuum full, this is normal.
Using a version > 7.4 then a normal vacuum "shall" be enough.
In response to
pgsql-admin by date
|Next:||From: Andy Marangakis||Date: 2004-10-25 18:48:54|
|Subject: runaway processes, data corruption|
|Previous:||From: Michael Fuhr||Date: 2004-10-25 17:30:06|
|Subject: Re: Psql question|