On 14 July 2010 17:16, Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx> wrote: > Ivan Voras <ivoras@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
