Skip site navigation (1) Skip section navigation (2)

Index relation size

From: "Rigmor Ukuhe" <rigmor(dot)ukuhe(at)finestmedia(dot)ee>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Index relation size
Date: 2004-10-25 11:02:46
Message-ID: (view raw or whole thread)
Lists: pgsql-admin

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 (
Version: 6.0.779 / Virus Database: 526 - Release Date: 19.10.2004


pgsql-admin by date

Next:From: Rajesh Kumar MallahDate: 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

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group