Re: Index relation size

Rigmor Ukuhe wrote:> Hi,>> I have table with size ~35 MB, it has several indexes and couple of them are> well over 500
MBin size (they are indexes with 3-4 columns involved, with> datatypes like varchar, int4 , timestamp, boolean).>
Databaseis VACUUMed nightly, version is 7.2.4 (cant upgrade to newest> version at the moment). Are these> index sizes
indicatingsome 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.


Regards
Gaetano Mendola