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: LNEIIJFMEEKIAIBMGCNGEEPFDAAA.rigmor.ukuhe@finestmedia.ee (view raw or flat)
Thread:
Lists: 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


Responses

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-2014 The PostgreSQL Global Development Group