Re: [BUGS] BUG #3639: queryplanner degrades to a sequential scan even if there's an index

2007-09-27 Thread Hannu Valtonen
Heikki Linnakangas kirjoitti: Hannu Valtonen wrote: explain analyze select * from table1, table2 where table1.table2_id = table2.id and table2.id = 2841962; Here the planner is using the partial index table2_id_index on table1, knowing that table1.table2_id equals 2841962, satisfying

[BUGS] BUG #3639: queryplanner degrades to a sequential scan even if there's an index

2007-09-27 Thread Hannu Valtonen
The following bug has been logged online: Bug reference: 3639 Logged by: Hannu Valtonen Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Debian Linux (4.0), kernel 2.6.20 Description:queryplanner degrades to a sequential scan even if