Postgres Pro
Downloads
Home   >   mailing lists

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

From P.J. \"Josh\" Rovero
Subject Re: One source of constant annoyance identified
Date
Msg-id 3D1C6117.6020109@sonalysts.com
Whole thread Raw
In response to Re: One source of constant annoyance identified  ("Markus Wollny" <Markus.Wollny@computec.de>)
List pgsql-general
Tree view 
Should have said:

"leading % forces a sequential scan".  Sorry

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.
>

--
P. J. "Josh" Rovero                                 Sonalysts, Inc.
Email: rovero@sonalysts.com    www.sonalysts.com    215 Parkway North
Work: (860)326-3671 or 442-4355                     Waterford CT 06385
***********************************************************************

pgsql-general by date:

Previous
From: Michael Meskes
Date:
Subject: Re: ecpg help
Next
From: "Markus Wollny"
Date:
Subject: FTI: help /w compiling/installation wanted (Full Text Index)