Maybe you should give tsearch2 a try and create a GIN index.
Regex searches are sometimes a option.
Robert
c k wrote:
> Hello all,
> As we are migrating our ERP application from MySQL to PostgreSQL we
> have some difficulties. One of them is use of Like and Similar to
> operators. We often use LIKE to search a string from front-end without
> case sensetivity. As postgreSQL's LIKE is case sensitive, we tried
> ILIKE and SIMILAR TO, but both are slower than LIKE and we must need
> case insensitivity. How can we get this by increases speed. All search
> columns are VARCHAR(100)to VARCHAR(250). Currently without index.
>
> Thanks,
> CPK