Re: [GENERAL] Why are my index files are much larger than mydatafiles

Or just simply a vacuum (with the analyze option) :)
-----Original Message-----
From: Ari Halberstadt <ari(at)shore(dot)net>
To: pgsql-general(at)postgreSQL(dot)org <pgsql-general(at)postgreSQL(dot)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(dot)j(dot)davis(at)tvguide(dot)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(at)shore(dot)net <http://www.magiccookie.com/>
>PGP public key available at <http://www.magiccookie.com/pgpkey.txt>
>
>
>