From: | Richard Poole <rp(at)guests(dot)deus(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Query plan w/ like clause question |
Date: | 2002-05-30 00:14:46 |
Message-ID: | 20020530001446.GA19616@guests.deus.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, May 29, 2002 at 03:58:53PM -0500, Steve Wranovsky wrote:
>
> I am having some strange results using a "like" clause under 7.2.1 w/ Linux.
...
> When I try to a like clause with a '%' wildcard that will return the
> same results as the exact match, the query does a sequential scan
> instead of using the index, and takes a significant amount of time
> to execute.
An index scan can't be used for a LIKE unless you're running in the C
locale, because other locales may have sorting rules which would give
incorrect results. Probably you're using en_US? Unfortunately you
need to re-run "initdb" to change this, which means dumping and
restoring your databases. See section 3.2 of the Administrator's
Guide.
Richard
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Robert Norris | 2002-05-30 01:11:36 | Re: How to cripple a postgres server |
Previous Message | Richard Poole | 2002-05-29 23:58:13 | Re: Query plan w/ like clause question |