Re: Problem with text_pattern_ops

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: Madison Kelly <linux(at)alteeve(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with text_pattern_ops
Date: 2005-07-26 22:00:20
Message-ID: 42E6B274.10401@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-07-26 22:08:34 Re: dropping non-existent tables
Previous Message Roman Neuhauser 2005-07-26 21:54:18 Re: back-end triggers front-end to update