Re: QP Problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "s d" <s(dot)d(dot)sauron(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: QP Problem
Date: 2007-05-19 23:20:34
Message-ID: 19410.1179616834@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"s d" <s(dot)d(dot)sauron(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message PFC 2007-05-20 14:58:45 Postgres Benchmark Results
Previous Message Ron Mayer 2007-05-19 22:38:12 Re: Background vacuum