Re: Performance regarding LIKE searches

From: Matthew Wakeling <matthew(at)flymine(dot)org>
To: randalls(at)bioinfo(dot)wsu(dot)edu
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance regarding LIKE searches
Date: 2010-03-30 09:34:55
Message-ID: alpine.DEB.2.00.1003301032570.9798@aragorn.flymine.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, 29 Mar 2010, randalls(at)bioinfo(dot)wsu(dot)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?

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Gnanakumar 2010-03-30 11:17:42 Re: Database size growing over time and leads to performance impact
Previous Message Gnanakumar 2010-03-30 09:32:23 REINDEXing database-wide daily