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