Re: Join optimization for inheritance tables - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Join optimization for inheritance tables
Date
Msg-id 4ABFBD3F.3010204@agliodbs.com
Whole thread Raw
In response to Re: Join optimization for inheritance tables  (Emmanuel Cecchet <manu@asterdata.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: pg_hba.conf: samehost and samenet [REVIEW]
Next
From: Stef Walter
Date:
Subject: Re: pg_hba.conf: samehost and samenet [REVIEW]