Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance regarding LIKE searches - Mailing list pgsql-performance

From Matthew Wakeling
Subject Re: Performance regarding LIKE searches
Date
Msg-id alpine.DEB.2.00.1003301032570.9798@aragorn.flymine.org
Whole thread Raw
In response to Performance regarding LIKE searches  (randalls@bioinfo.wsu.edu)
List pgsql-performance
Tree view 
On Mon, 29 Mar 2010, randalls@bioinfo.wsu.edu wrote:
> WHERE ... lower(n.name) LIKE 'Scaffold:scaffold_163:1000..1199%' ...

I'm sure you noticed that this is never going to return any rows?

Matthew

--
 Me... a skeptic?  I trust you have proof?

pgsql-performance by date:

Previous
From: "Gnanakumar"
Date:
Subject: REINDEXing database-wide daily
Next
From: "Gnanakumar"
Date:
Subject: Re: Database size growing over time and leads to performance impact