"Christopher Condit" <condit@xxxxxxxx> writes: > Although, once you've built the index with varchar_pattern_ops index, > the following two (essentially equivalent) queries will run at vastly > different speeds: > select * from A where A.value like 'Nacho'; > select * from A where A.value = 'Nacho'; > Seems that the optimizer should catch this... Yeah, it's on the to-do list ... http://archives.postgresql.org/pgsql-hackers/2008-02/msg01003.php regards, tom lane
