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

Re: Index not used on join with inherited tables

From: Sebastian Böck <sebastianboeck(at)freenet(dot)de>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Index not used on join with inherited tables
Date: 2005-05-30 16:36:39
Message-ID: 429B4117.1050103@freenet.de (view raw or flat)
Thread:
Lists: pgsql-performance
Josh Berkus wrote:
> Sebastian,
> 
> 
>>I'm having another problem with a query that takes to long, because
>>the appropriate index is not used.
> 
> 
> PostgreSQL is not currently able to push down join criteria into UNIONed 
> subselects.   It's a TODO.

And the appends in a "SELECT * from parent" are UNIONs, aren't they?

> Also, if you're using inherited tables, it's unnecessary to use UNION; just 
> select from the parent.

Yes, but then no index is used...

Sebastian



In response to

pgsql-performance by date

Next:From: Steve AtkinsDate: 2005-05-30 16:53:40
Subject: Re: sequential scan performance
Previous:From: Michael EngelhartDate: 2005-05-30 16:33:28
Subject: Re: sequential scan performance

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