Re: Join optimization for inheritance tables

On 9/26/09 3:00 PM, Emmanuel Cecchet wrote:
> Hi Simon,
>
> Thanks for the insight. I might take that as a long term project. I have
> to discuss that with my colleagues at Aster. It would certainly help to
> put together a wiki page with the key insights on the design of such
> implementation to be able to better scope the project and agree on what
> is the right approach for this.

In the meantime, can you look at the possibility I suggested? If you
could produce a patch which would implement the most common and least
complex case of partition joining: where the constraints on two
partitions match exactly (or are mathematically provable subsets) with a
small patch, it would probably work for 8.5.

--
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com