Thread: QP Problem

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 postgres 8.2
Thanks,
S.

"s d" <s.d.sauron@gmail.com> 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.

Please show the details: the table definitions, exact query, and plan.

            regards, tom lane