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).
cheers andrew ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
