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
In response to
pgsql-patches by date
|Next:||From: Tom Lane||Date: 2007-08-01 22:54:47|
|Subject: Re: Async Commit, v21 (now: v22) |
|Previous:||From: Pavel Ajtkulov||Date: 2007-08-01 20:18:22|
|Subject: strpos() && KMP|