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

From Tom Lane
Subject Re: Join optimization for inheritance tables
Date
Msg-id 11534.1253674357@sss.pgh.pa.us
Whole thread Raw
In response to Re: Join optimization for inheritance tables  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Join optimization for inheritance tables
List pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> I don't think that waiting for our plans for a more robust partitioning
> implementation is a reason to put off improvements to the implementation
> we have.

The complaint I had was that this patch consisted largely of code that
we'd want to throw away once a better partitioning implementation is in
place.  I don't object to partial patches that move us forward on the
agreed-on path, but this one seemed to be going sideways.

> What about simply eliminating joins between partitioned tables by
> checking which columns' constraints match exactly or are subsets?

If it could be done with a <emphasis>small</> amount of throwaway
code, maybe ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Gierth
Date:
Subject: latest hstore patch
Next
From: Robert Haas
Date:
Subject: Re: LATERAL