From: | yuliada <yuliada(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Slow select |
Date: | 2009-12-17 01:18:12 |
Message-ID: | 26821568.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Sam Mason wrote:
>
> Wouldn't this be "lower(value) = lower(?)" ?
>
Yes, I use it as "lower(value) = lower(?)", I typed inaccurate example.
Sam Mason wrote:
>
> So each query is taking approx 300ms? How much data does each one
> return?
>
No more than 1000 rows.
Sam Mason wrote:
>
> How about combining all 1000 selects into one?
>
I can't combine these selects into one, I need to run them one after
another.
Grzegorz Jaśkiewicz wrote:
>
> show us explain select * ....
>
"Bitmap Heap Scan on bn_stringvalue v (cost=228.40..8688.70 rows=2172
width=90) (actual time=1129.767..1781.403 rows=104 loops=1)"
" Recheck Cond: (lower((value)::text) = 'esr'::text)"
" -> Bitmap Index Scan on idx_stringv (cost=0.00..227.86 rows=2172
width=0) (actual time=1107.974..1107.974 rows=104 loops=1)"
" Index Cond: (lower((value)::text) = 'esr'::text)"
"Total runtime: 1781.566 ms"
Thanks
--
View this message in context: http://old.nabble.com/Slow-select-tp26810673p26821568.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | yuliada | 2009-12-17 01:49:44 | Re: Slow select |
Previous Message | Justin Bailey | 2009-12-17 01:05:19 | Automatic truncation of character values & casting to the type of a column type |