Re: Looking for a fix to index bloat - Mailing list pgsql-general

From Roger Hand
Subject Re: Looking for a fix to index bloat
Date
Msg-id DB28E9B548192448A4E8C8A3C1B1E475FC32E4@sj1-exch-01.us.corp.kailea.com
Whole thread Raw
In response to Looking for a fix to index bloat  (bfraci@aol.com)
Responses Re: Looking for a fix to index bloat  (bfraci@aol.com)
List pgsql-general
bfraci@aol.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Size comparison between a Composite type and an
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Size comparison between a Composite type and an