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

From: Ari Halberstadt <ari(at)shore(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Why are my index files are much larger than my datafiles
Date: 1999-04-27 06:00:23
Message-ID: v04003a00b34b02b0a82d@[192.168.1.2]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adriaan Joubert 1999-04-27 06:09:50 Re: [GENERAL] advice on buying sun hardware to run postgres
Previous Message Andy Lewis 1999-04-27 03:57:44 PL/pgSQL