Re: Join optimization for inheritance tables

On Tue, 2009-09-22 at 18:16 -0400, Emmanuel Cecchet wrote:
> If the partitioning implementation does not make progress (and does not 
> make it for 8.5), don't you think that this could be an interesting 
> contribution to consider for this release?
> I have put on the wiki 
> (http://wiki.postgresql.org/wiki/Join_optimization_for_inheritance_tables) 
> the results obtained so far and the use case where it is most used.

I think you mean that the planning time is in milliseconds, not seconds.
Also, you use "data" in a few places you meant "date".

The results seem good, and trading planning time for execution time
seems like a reasonable idea in the case of partitioned tables. We
already work harder planning when constraint_exclusion='partition', so
there is some precedent (I don't know if that's a good precedent to
follow or not).

How does it compare to using merge-append?

I haven't looked at the actual patch yet.

Regards,Jeff Davis