> 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.
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Michael Engelhart||Date: 2005-05-30 16:33:28|
|Subject: Re: sequential scan performance|
|Previous:||From: Josh Berkus||Date: 2005-05-30 16:19:40|
|Subject: Re: Postgresql and xeon.|