QP Problem - Mailing list pgsql-performance

From s d
Subject QP Problem
Date
Msg-id 24b53fa00705191508i36fbf192me7152c79bf2ec50f@mail.gmail.com
Whole thread Raw
Responses Re: QP Problem
List pgsql-performance
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.

pgsql-performance by date:

Previous
From: Guido Neitzer
Date:
Subject: Re: performance drop on 8.2.4, reverting to 8.1.4
Next
From: Ron Mayer
Date:
Subject: Re: Background vacuum