Re: Problem with text_pattern_ops - Mailing list pgsql-general

From Joseph Shraibman
Subject Re: Problem with text_pattern_ops
Date
Msg-id 42E6B274.10401@selectacast.net
Whole thread Raw
In response to Re: Problem with text_pattern_ops  (Madison Kelly <linux@alteeve.com>)
List pgsql-general

Madison Kelly wrote:
> Joseph Shraibman wrote:
>

>   What happens if you 'SET enable_seqscan TO OFF' and try the query
> again? I've had a couple of instances where the planner just doesn't
> like my index but once it is told to use it I get a nice performance boost.

It still does a seqscan.
>

pgsql-general by date:

Previous
From: Roman Neuhauser
Date:
Subject: Re: back-end triggers front-end to update
Next
From: Michael Fuhr
Date:
Subject: Re: dropping non-existent tables