Re: tsearch2 and gist index bloat - Mailing list pgsql-general

From George Essig
Subject Re: tsearch2 and gist index bloat
Date
Msg-id 20031106192440.25052.qmail@web80205.mail.yahoo.com
Whole thread Raw
In response to Re: tsearch2 and gist index bloat  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-general
--- Oleg Bartunov <oleg@sai.msu.su> wrote:
> On Thu, 6 Nov 2003, George Essig wrote:
>
> > Thanks for the reply.  For this project, I can update the data and reindex during off-peak
> hours.
> > I was just surprised to see the size of the index double after heavy write activity.
> >
>
> This is not tsearch specific problem. It was discussed several times, ]
> see index bloat subject in archives.
>
>     Oleg
>

I understand that index bloat is a general problem, but is this particular problem more severe
because of a gist index?  By the way, I'm running PostgreSQL 7.4 Release Candidate 1.

Thanks,
George Essig

pgsql-general by date:

Previous
From: "Carlos Oliva"
Date:
Subject: Re: Install files for version 7.4
Next
From: Manfred Koizar
Date:
Subject: Re: Help on update that subselects other records in table, uses joins