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: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
On Mon, 29 Mar 2010, randalls(at)bioinfo(dot)wsu(dot)edu wrote:
> WHERE ... lower( LIKE 'Scaffold:scaffold_163:1000..1199%' ...

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


 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-2017 The PostgreSQL Global Development Group