"Kevin Grittner" <Kevin.Grittner@xxxxxxxxxxxx> writes: > To be clear, though, the problem isn't that it didn't turn a LIKE > with no wildcard characters into an equality test, it's that it > would have been three orders of magnitude faster (because of an > available index with an opclass specification) if it had treated an > equality test as a LIKE. Ah. Well, the real fix for that is also in 8.4: we got rid of the separate ~=~ operator, so a text_pattern_ops index is now usable for plain =. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
