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
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
[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