Tom Lane wrote: > The problem seems to be mostly tsearch2's fault rather than the general > GIST code. I've applied a partial fix to 8.1 and HEAD branches, which > you can find here if you're in a hurry for it: > http://archives.postgresql.org/pgsql-committers/2006-01/msg00283.php > (the gistidx.c change is all you need for tsearch2) Thanks for all your time and work you and the other guys are spending on this matter! I'll look into the new version, but a.p.o seems to be unreachable at the moment. > There is some followup discussion in the pgsql-performance list. It > seems possible that we can get another factor of 10 or better with a > smarter picksplit algorithm --- but that patch will probably be too > large to be considered for back-patching into the stable branches. I've already been following the discussion on pgsql-perform, although I have to admit that don't understand every detail of the tsearch2 implementation. :-) Thus, I'm sorry that I won't be able to help directly on that problem. But it is interesting to read anyway. Best regards, - Stephan
Attachment:
signature.asc
Description: OpenPGP digital signature
