Re: [PERFORM] QP Problem

2007-05-19 Thread Tom Lane
"s d" <[EMAIL PROTECTED]> writes: > I have about 6 tables that inherit from one table. They all have the > exact same indexes but when i try to query all by a row (which is > indexed, btree) the QP decides to do sequential scan for some of them > (the bigger tables) rather than use the index. Plea

[PERFORM] QP Problem

2007-05-19 Thread s d
Hi, I have about 6 tables that inherit from one table. They all have the exact same indexes but when i try to query all by a row (which is indexed, btree) the QP decides to do sequential scan for some of them (the bigger tables) rather than use the index. Any ideas why that may happen? I am using