Postgres Pro
Downloads
Home   >   mailing lists

Re: One source of constant annoyance identified - Mailing list pgsql-general

From nconway@klamath.dyndns.org (Neil Conway)
Subject Re: One source of constant annoyance identified
Date
Msg-id 20020628140947.GA3807@klamath.dyndns.org
Whole thread Raw
In response to Re: One source of constant annoyance identified  ("P.J. \"Josh\" Rovero" <rovero@sonalysts.com>)
List pgsql-general
Tree view 
On Fri, Jun 28, 2002 at 07:40:46AM -0400, P.J. Josh Rovero wrote:
> LIKE '%dfjdsklfdfjdklfjds' is what is killing you.
>
> LIKE 'sdfdklf%' can be indexed, but the leading wildcard
> forces an index search.

You mean it forces a sequential scan, of course.

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC

pgsql-general by date:

Previous
From: "Markus Wollny"
Date:
Subject: Re: One source of constant annoyance identified
Next
From: Tom Lane
Date:
Subject: Re: 7.2.1 optimises very badly against 7.2