Re: Looking for a fix to index bloat

From: "Roger Hand" <rhand(at)ragingnet(dot)com>
To: <bfraci(at)aol(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Looking for a fix to index bloat
Date: 2006-03-01 17:32:24
Message-ID: DB28E9B548192448A4E8C8A3C1B1E475FC32E4@sj1-exch-01.us.corp.kailea.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

bfraci(at)aol(dot)com wrote on
Tuesday, February 28, 2006 7:13 AM
> We are suffering from the same issue that is described in this email thread
> http://archives.postgresql.org/pgsql-general/2005-07/msg00486.php.
>
> I don't know if this is the appropriate place to make this request, so if
> not, please forgive me. However, in our particular case, we don't have enough
> disk space nor money to allow the indexes to grow to a steady state.

This isn't what you asked for, but if you can afford a modest amount of
downtime you could always drop/recreate the indexes.

-Roger

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-03-01 17:37:55 Re: Size comparison between a Composite type and an
Previous Message Tom Lane 2006-03-01 16:52:12 Re: Size comparison between a Composite type and an