Index relation size - Mailing list pgsql-admin

From Rigmor Ukuhe
Subject Index relation size
Date
Msg-id LNEIIJFMEEKIAIBMGCNGEEPFDAAA.rigmor.ukuhe@finestmedia.ee
Whole thread Raw
Responses Re: Index relation size
Re: Index relation size
List pgsql-admin
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?

Rigmor Ukuhe
---
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:

Previous
From: Tom Lane
Date:
Subject: Re: db rename
Next
From: "Goulet, Dick"
Date:
Subject: Psql question