Postgres Pro
Downloads
Home   >   mailing lists

Re: Vacuum - Mailing list pgsql-admin

From Tom Lane
Subject Re: Vacuum
Date
Msg-id 19565.1007058635@sss.pgh.pa.us
Whole thread Raw
In response to Vacuum  (bangh <banghe@baileylink.net>)
Responses Re: Vacuum  (Brian McCane <bmccane@mccons.net>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: bangh
Date:
Subject: Re: table test
Next
From: Stephan Szabo
Date:
Subject: Re: Vaccum