LIKE pattern
От
Владимир
Тема
LIKE pattern
Дата
Msg-id
572C6851.7010600@krevedko.su
Список
Дерево обсуждения
LIKE pattern Владимир <vovka@krevedko.su>
Re: LIKE pattern SoDupuDupu <playtoh87@gmail.com>
Re: LIKE pattern Robert Klemme <shortcutter@googlemail.com>
Re: LIKE pattern Jeff Janes <jeff.janes@gmail.com>
Re: LIKE pattern Tom Lane <tgl@sss.pgh.pa.us>
Hello. It seems my quite complex query runs 10 times faster on "some_column LIKE '%test_1' " vs "some_column LIKE 'test_1' " So I just add "%" to the pattern... Both query plans use same indexes.
В списке pgsql-performance по дате отправления
