Or just simply a vacuum (with the analyze option) :)
-----Original Message-----
From: Ari Halberstadt <ari@shore.net>
To: pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.org>
Date: Monday, April 26, 1999 11:55 PM
Subject: Re: [GENERAL] Why are my index files are much larger than
mydatafiles
>Michael J Davis <michael.j.davis@tvguide.com> wrote:
>>...
>>The first index is three int4 values. The second index is one int4 value.
>>Why are the index files so large? What can I do to reclaim the disk
space.
>>This is after a vacuum. PostgreSQL 6.5 as of 4/25/99. Red Hat 5.1 intel
>>pentium II.
>
>You could do a drop index followed by a create index followed by a vacuum.
>
>-- Ari Halberstadt mailto:ari@shore.net <http://www.magiccookie.com/>
>PGP public key available at <http://www.magiccookie.com/pgpkey.txt>
>
>
>
