On 14 July 2010 17:16, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> Ivan Voras <ivoras(at)freebsd(dot)org> wrote:
>
>> which didn't help.
>
> Didn't help what? You're processing each row in 22.8 microseconds.
> What kind of performance were you expecting?
Well, I guess you're right. What I was expecting is a large bump in
speed going from LIKE to tsearch2 but then there's also record
processing outside the index itself, which is probably where the time
goes.