| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajesh Kumar Mallah | 2004-10-25 11:26:18 | Re: '<IDLE> in transaction' problem in mod_perl/DBI/DBD-Pg |
| Previous Message | Vishal Kashyap @ [Sai Hertz And Control Systems] | 2004-10-25 09:08:54 | Re: Upgrading to 7.4.5 |