Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: bug.sql
Description: text/plain (1.3 KB)

Responses

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group