Re: Tsearch2 index size

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: richard-pgodbc(at)armchair(dot)mb(dot)ca
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Tsearch2 index size
Date: 2006-10-23 19:33:52
Message-ID: 27663.1161632032@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

richard-pgodbc(at)armchair(dot)mb(dot)ca writes:
> 1. The release notes indicate "more efficient vacuuming." However, both
> vacuums seems to take about the same amount of time, ie. approx: 9 hours.

I think the improvements were only in btree index vacuuming, which it
sounds like isn't your big problem.

> 2. I have a tsearch2 index which is 756MB in size in 8.1.2 but balloons to
> 910MB in 8.2!

FILLFACTOR?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeremy Drake 2006-10-23 19:43:40 Re: New CRC algorithm: Slicing by 8
Previous Message Tom Lane 2006-10-23 19:21:09 Re: New CRC algorithm: Slicing by 8