Index not used on join with inherited tables

From: Sebastian Böck <sebastianboeck(at)freenet(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Subject: Index not used on join with inherited tables
Date: 2005-05-30 15:54:28
Message-ID: 429B3734.2020609@freenet.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi all,

I'm having another problem with a query that takes to long, because
the appropriate index is not used.

I found some solutions to this problem, but I think Postgres should do
an index scan in all cases.

To show the problem I've attached a small script with a testcase.

Thanks in advance

Sebastian

Attachment Content-Type Size
bug.sql text/plain 1.3 KB

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2005-05-30 16:19:40 Re: Postgresql and xeon.
Previous Message Michael Fuhr 2005-05-30 13:54:29 Re: timestamp indexing