Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group