Re: Index relation size - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: Index relation size
Date
Msg-id 417D3D03.5020102@bigfoot.com
Whole thread Raw
In response to Index relation size  ("Rigmor Ukuhe" <rigmor.ukuhe@finestmedia.ee>)
List pgsql-admin
Rigmor Ukuhe wrote:> Hi,>> I have table with size ~35 MB, it has several indexes and couple of them are> well over 500
MBin size (they are indexes with 3-4 columns involved, with> datatypes like varchar, int4 , timestamp, boolean).>
Databaseis VACUUMed nightly, version is 7.2.4 (cant upgrade to newest> version at the moment). Are these> index sizes
indicatingsome problems with our Postgres server? 

If you do not vacuum full, this is normal.
Using a version > 7.4 then a normal vacuum "shall" be enough.


Regards
Gaetano Mendola




pgsql-admin by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Psql question
Next
From: Ben Kim
Date:
Subject: Question: drop database problem