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

Re: Index relation size

From: "Scott Marlowe" <smarlowe(at)qwest(dot)net>
To: "Rigmor Ukuhe" <rigmor(dot)ukuhe(at)finestmedia(dot)ee>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Index relation size
Date: 2004-10-26 00:44:33
Message-ID: 1098751473.31930.11.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-admin
On Mon, 2004-10-25 at 05:02, 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?

Assuming you aren't suffering from index bloat, which was a problem in
7.2, this may be normal.  To see if you are, try "reindex indexname" and
see if the index shrinks.

Multicolumn indexes being bigger than their table because of the way
they're put together, so it's likely that when you get done reindexing
the index will still be bigger than the table.


In response to

pgsql-admin by date

Next:From: Greg Sabino MullaneDate: 2004-10-26 01:36:21
Subject: Re: '<IDLE> in transaction' problem in mod_perl/DBI/DBD-Pg environment.
Previous:From: Tom LaneDate: 2004-10-25 23:33:35
Subject: Re: Question: drop database problem

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