> I have 7.2.4 running on a Sun box, so I tried that too, with similar
> results. tsearch just doesn't seem to work very well on this dataset
> (or any other large dataset I've tried).
Well, as I've shown - works fine for me...
I strongly suggest you repost your problem report to -hackers, since the
fact that the tsearch developers haven't chimed in implies to me that
they don't watch the performance list.
BTW, read this about Gist indexes:
(Note lack of concurrency)
In response to
pgsql-performance by date
|Next:||From: Kamalraj Singh Madhan||Date: 2003-12-01 10:17:47|
|Subject: Dump restoration via archive files|
|Previous:||From: Steve Atkins||Date: 2003-11-28 20:37:00|
|Subject: Re: For full text indexing, which is better, tsearch2 or|