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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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