Re: [HACKERS] Tsearch2 index size

2006-11-02 Thread Jeff Davis
On Mon, 2006-10-23 at 13:36 -0500, [EMAIL PROTECTED] wrote: > 2. I have a tsearch2 index which is 756MB in size in 8.1.2 but balloons to > 910MB in 8.2! These numbers were taken right after a REINDEX. Normally, I > wouldn't care about physical index size, but this particular index is > sitting

Re: [HACKERS] Tsearch2 index size

2006-10-23 Thread richard-pgodbc
2. I have a tsearch2 index which is 756MB in size in 8.1.2 but balloons to 910MB in 8.2! FILLFACTOR? Tom, Of course! I had it in my head that fillfactor had to be explicitely set. But then, after RTFM, it looks like there are defaults! Thank you! One more inane question, though. Th

Re: [HACKERS] Tsearch2 index size

2006-10-23 Thread Tom Lane
[EMAIL PROTECTED] 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