Re: Index not used on join with inherited tables - Mailing list pgsql-performance

From Sebastian Böck
Subject Re: Index not used on join with inherited tables
Date
Msg-id 429B4117.1050103@freenet.de
Whole thread Raw
In response to Re: Index not used on join with inherited tables  (Josh Berkus <josh@agliodbs.com>)
List 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



pgsql-performance by date:

Previous
From: Michael Engelhart
Date:
Subject: Re: sequential scan performance
Next
From: Steve Atkins
Date:
Subject: Re: sequential scan performance