Re: ~* + LIMIT => infinite time? - Mailing list pgsql-performance

Typea,

> At the moment, I've altered the application to not use LIMIT when I
> have
> ~* in the query, and it "works" -- only the paging of results is
> broken,

Would your application allow you to use " ILIKE '%<VALUE>%'" in the
query instead of "~*"  ?  If so, does the query still hang with ILIKE
... LIMIT?

-Josh