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
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
