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?
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.779 / Virus Database: 526 - Release Date: 19.10.2004
pgsql-admin by date
|Next:||From: Rajesh Kumar Mallah||Date: 2004-10-25 11:26:18|
|Subject: Re: '<IDLE> in transaction' problem in mod_perl/DBI/DBD-Pg|
|Previous:||From: Vishal Kashyap @ [Sai Hertz And Control Systems]||Date: 2004-10-25 09:08:54|
|Subject: Re: Upgrading to 7.4.5|