Postgres Pro
Downloads
Home   >   mailing lists

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

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

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Postgresql and xeon.
Next
From: Michael Engelhart
Date:
Subject: Re: sequential scan performance