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

2005-05-25 Thread Jocelyn Turcotte
gt; wrote: > Jocelyn Turcotte wrote: > > >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. > > > > > > The only thing that *might* work is if you used an ind

[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 e.star