Re: Understanding tsearch2 performance - Mailing list pgsql-performance

From Ivan Voras
Subject Re: Understanding tsearch2 performance
Date
Msg-id AANLkTik1zzx4ni4cFxuyQMAYCTCiSwdowrNlG4-drkiK@mail.gmail.com
Whole thread Raw
In response to Re: Understanding tsearch2 performance  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
On 14 July 2010 17:16, Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote:
> Ivan Voras <ivoras@freebsd.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.

pgsql-performance by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Need help in performance tuning.
Next
From: Scott Carey
Date:
Subject: Re: performance on new linux box