On 14 July 2010 17:16, Kevin Grittner <kevin.gritt...@wicourts.gov> wrote: > Ivan Voras <ivo...@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. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
