Dave,
> Is there further optimizations we can do to change the plan?
> Is this perhaps addressed in a later release?
Given the left joins, a later release might help; I know we did a lot to
improve left join plans in 8.3. It would be worth testing if you can
test an upgrade easily.
--
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com