QP Problem

From: "s d" <s(dot)d(dot)sauron(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: QP Problem
Date: 2007-05-19 22:08:07
Message-ID: 24b53fa00705191508i36fbf192me7152c79bf2ec50f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ron Mayer 2007-05-19 22:38:12 Re: Background vacuum
Previous Message Guido Neitzer 2007-05-19 19:51:04 Re: performance drop on 8.2.4, reverting to 8.1.4