Rigmor Ukuhe wrote:
> Hi,
>
> 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.
Regards
Gaetano Mendola