| From: | George Essig <george_essig(at)yahoo(dot)com> |
|---|---|
| To: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
| Cc: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: tsearch2 and gist index bloat |
| Date: | 2003-11-06 19:24:40 |
| Message-ID: | 20031106192440.25052.qmail@web80205.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
--- Oleg Bartunov <oleg(at)sai(dot)msu(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Manfred Koizar | 2003-11-06 19:41:08 | Re: Help on update that subselects other records in table, uses joins |
| Previous Message | Carlos Oliva | 2003-11-06 19:00:36 | Re: Install files for version 7.4 |