I have a table called jobs with ~17 millions records. Without an index on
the queue column, the following query
select count(*) from jobs where lower(queue) = 'normal'
found ~2.6 millions records in 10160ms
With the following index:
create index lower_queue on jobs (lower(queue))
th
> Subject: Re: [pgadmin-support] [GENERAL] Postgres case
insensitive searches
> From: haram...@gmail.com
> Date: Sat, 29 Jun 2013 09:37:51 +0200
> CC: laurenz.a...@wien.gv.at;
pgsql-general@postgresql.org;
On Jun 29, 2013, at 15:02, bhanu udaya wrote:
> I agree that it is just search condition. But, in a 2.5 million record table
> search, upper function is not that fast.
Suit yourself, the solution is there.
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll
we are using is Linux 64 bit.
Thanks and Regards
Radha Krishna
> Subject: Re: [pgadmin-support] [GENERAL] Postgres case insensitive searches
> From: haram...@gmail.com
> Date: Sat, 29 Jun 2013 09:37:51 +0200
> CC: laurenz.a...@wien.gv.at; pgsql-general@postgresql.org;
&g
