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) ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
