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

Re: Index relation size

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Rigmor Ukuhe <rigmor(dot)ukuhe(at)finestmedia(dot)ee>
Subject: Re: Index relation size
Date: 2004-10-25 17:50:59
Message-ID: 417D3D03.5020102@bigfoot.com (view raw or flat)
Thread:
Lists: 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 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?

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


Regards
Gaetano Mendola




In response to

pgsql-admin by date

Next:From: Andy MarangakisDate: 2004-10-25 18:48:54
Subject: runaway processes, data corruption
Previous:From: Michael FuhrDate: 2004-10-25 17:30:06
Subject: Re: Psql question

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