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?
Me... a skeptic? I trust you have proof?
In response to
pgsql-performance by date
|Next:||From: Gnanakumar||Date: 2010-03-30 11:17:42|
|Subject: Re: Database size growing over time and leads to performance impact|
|Previous:||From: Gnanakumar||Date: 2010-03-30 09:32:23|
|Subject: REINDEXing database-wide daily|