Received: from sss.pgh.pa.us ([192.204.191.242])
	by postgresql.org (8.11.3/8.11.4) with ESMTP id fATIUkm89157
	for <pgsql-admin@postgresql.org>; Thu, 29 Nov 2001 13:30:47 -0500 (EST)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id fATIUZk19568;
	Thu, 29 Nov 2001 13:30:35 -0500 (EST)
To: bangh <banghe@baileylink.net>
cc: "'pgsql-admin@postgresql.org'" <pgsql-admin@postgresql.org>
Subject: Re: Vacuum 
In-reply-to: <3C065CEA.B23D9745@baileylink.net> 
References: <20011127085555.A20745-100000@megazone23.bigpanda.com>
	<3C04A23E.BF409D74@answare.fr> <2131.1006960265@sss.pgh.pa.us>
	<3C0510FF.694D34EA@answare.fr> <2528.1006965329@sss.pgh.pa.us>
	<3C051482.908DEDFF@answare.fr> <2775.1006967609@sss.pgh.pa.us>
	<3C05F979.ED76D96D@answare.fr> <18157.1007043873@sss.pgh.pa.us>
	<18448.1007046370@sss.pgh.pa.us> <3C065CEA.B23D9745@baileylink.net>
Comments: In-reply-to bangh <banghe@baileylink.net>
	message dated "Thu, 29 Nov 2001 10:06:02 -0600"
Date: Thu, 29 Nov 2001 13:30:35 -0500
Message-ID: <19565.1007058635@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200111/176
X-Sequence-Number: 2701

bangh <banghe@baileylink.net> writes:
> However I noticed the index grows also very fast. Does anyone have a way to
> compress the index?

REINDEX, or just drop and recreate the indexes.

			regards, tom lane