Pavel Ajtkulov wrote:
Also, I advise to use "select .. where strpos(att, 'word') > 0;" instead "select .. 
where attr like '%word%'"
(strpos must be faster than regex).

The LIKE code does not use the regex engine. See src/backend/utils/adt/like.c and like_match.c - which recently got an efficiency makeover, especially for MB charsets (and most especially for UTF8).



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to