[PERFORM] Inner join on two OR conditions dont use index

2005-05-25 Thread Jocelyn Turcotte
Hi all i dont know if this is normal, but if yes i would like to know why and how I could do it another way other than using unions. (I tried on postgresql 7.4 and 8.0.3, made my vacuum analyse just before) Here is my simple query: select * from rt_node n, rt_edge e where node_id = 2 and

Re: [PERFORM] Inner join on two OR conditions dont use index

2005-05-25 Thread Jocelyn Turcotte
) Index Cond: ((start_node_id = $0) OR (end_node_id = $0)) this time it use my two indexes, maybe because he know that the same value is compared in the two condition... I should ask my mother if she got an idea, mothers know a lot of stuff! On 5/25/05, John A Meinel [EMAIL PROTECTED] wrote: Jocelyn