[PERFORM] Bad plan when join on function

2011-01-17 Thread Zotov
It`s just a sample. select c.id from OneRow c join abstract a on a.id=AsInteger(c.id) "Nested Loop (cost=0.00..786642.96 rows=1 width=4) (actual time=91021.167..119601.344 rows=1 loops=1)" " Join Filter: ((a.id)::integer = asinteger((c.id)::integer))" " -> Seq Scan on onerow c (cost=0.00.

[PERFORM] Query optimization problem

2010-07-14 Thread Zotov
I have a query: SELECT d1.ID, d2.ID FROM DocPrimary d1 JOIN DocPrimary d2 ON d2.BasedOn=d1.ID WHERE (d1.ID=234409763) or (d2.ID=234409763) i think what QO(Query Optimizer) can make it faster (now it seq scan and on million records works 7 sec) SELECT d1.ID, d2.ID FROM DocPrimary d1 J