| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | "Carlos H(dot) Reimer" <carlos(dot)reimer(at)opendb(dot)com(dot)br> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: RES: Improving select peformance |
| Date: | 2007-08-01 16:52:48 |
| Message-ID: | 20070801165248.GF10324@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Carlos H. Reimer wrote:
> Hi,
>
> I have changed the view to eliminate the bizarre concatenation conditions
> but even so the response time did not change.
Are you sure you did that? In the EXPLAIN it's still possible to see
them, for example
> -> Nested Loop (cost=1.34..3409.04 rows=1 width=159)
> (actual time=0.237..32.520 rows=414 loops=1)
> Join Filter: ((gra.codtam)::text = ((sub.codite)::text
> || ''::text))
> -> Nested Loop (cost=1.34..3376.84 rows=28 width=136)
> (actual time=0.226..20.978 rows=414 loops=1)
> -> Hash Join (cost=1.34..3356.99 rows=28
> width=145) (actual time=0.215..15.225 rows=414 loops=1)
> Hash Cond: ((gra.codcor)::text =
> ((div.codite)::text || ''::text))
--
Alvaro Herrera http://www.amazon.com/gp/registry/CTMLCN8V17R4
"Uno combate cuando es necesario... ¡no cuando está de humor!
El humor es para el ganado, o para hacer el amor, o para tocar el
baliset. No para combatir." (Gurney Halleck)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Dittmer | 2007-08-01 17:37:11 | Re: select on 1milion register = 6s |
| Previous Message | Carlos H. Reimer | 2007-08-01 15:12:39 | RES: Improving select peformance |