From: Scott Marlowe <smarlowe@qwest.net>
To: Rigmor Ukuhe <rigmor.ukuhe@finestmedia.ee>
Cc: pgsql-admin@postgresql.org
Subject: Re: Index relation size
Date: Mon, 25 Oct 2004 18:44:33 -0600
Message-ID: <1098751473.31930.11.camel@localhost.localdomain> (raw)
In-Reply-To: <LNEIIJFMEEKIAIBMGCNGEEPFDAAA.rigmor.ukuhe@finestmedia.ee>
References: <LNEIIJFMEEKIAIBMGCNGEEPFDAAA.rigmor.ukuhe@finestmedia.ee>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: smarlowe@qwest.net, rigmor.ukuhe@finestmedia.ee
Subject: Re: Index relation size
In-Reply-To: <1098751473.31930.11.camel@localhost.localdomain>
References: <LNEIIJFMEEKIAIBMGCNGEEPFDAAA.rigmor.ukuhe@finestmedia.ee> <1098751473.31930.11.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox