Re: [HACKERS] Strange postgres planner behaviour

2005-03-13 Thread Oleg Bartunov
On Sat, 12 Mar 2005, Tom Lane wrote: "Sergey E. Koposov" <[EMAIL PROTECTED]> writes: I want to descibe some strange behaviour of the postgres planner. It's not strange exactly: the mechanism for OR indexscan and the mechanism for nestloop join indexscan are separate and don't talk to each other. S

Re: [HACKERS] Strange postgres planner behaviour

2005-03-12 Thread Tom Lane
"Sergey E. Koposov" <[EMAIL PROTECTED]> writes: > I want to descibe some strange behaviour of the postgres planner. It's not strange exactly: the mechanism for OR indexscan and the mechanism for nestloop join indexscan are separate and don't talk to each other. So you don't get to have a join inn

[HACKERS] Strange postgres planner behaviour

2005-03-12 Thread Sergey E. Koposov
Hi All, I want to descibe some strange behaviour of the postgres planner. I have 2 tables: wsdb=# \d q3c Table "public.q3c" Column | Type | Modifiers ++--- ipix | bigint | errbox | box| ra | real | dec| real | Indexes: "ipix_idx" b