Re: 'query was cancelled' - depending on search pattern

Bernd von den Brincken <bvdb@asa.de> writes:
> a query that uses pattern matching like this:
>    SELECT .. WHERE  ( (content || authorname) ~* ( '.*gesellschaft.* |
> .*wirtschaft.*' ) )
> produces an error 'Query was cancelled' - sometimes, depending on the
> search words.

That's really, really hard to believe.  I suspect you've mis-analyzed
the situation.  You sure your client-side code doesn't send cancel
requests on occasion?  Can you create a test case that would let someone
else reproduce this behavior?

            regards, tom lane