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
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