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

Re: Index not used on join with inherited tables

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Sebastian Böck <sebastianboeck(at)freenet(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Index not used on join with inherited tables
Date: 2005-05-30 16:21:46
Message-ID: 200505300921.46460.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
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. 

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

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

pgsql-performance by date

Next:From: Michael EngelhartDate: 2005-05-30 16:33:28
Subject: Re: sequential scan performance
Previous:From: Josh BerkusDate: 2005-05-30 16:19:40
Subject: Re: Postgresql and xeon.

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