Herodotos Herodotou escreveu: > This patch extends the query optimizer to consider joins between child tables > when hierarchies are joined together. > > Short description: when the optimizer considers join paths between two tables > with child tables, it only creates join paths over two append paths. In this > patch we extend the optimizer to consider joins between the child tables from > the two parent relations, based on the child table constraints. The idea is > that only child tables with overlapping constraints need to be joined, and > not the entire hierarchies with each other. This optimization can provide > significant benefits in terms of execution time. A short motivation example > as well as the overall algorithm description could be found in the attached > presentation. > I added it to the next commitfest [1].
[1] https://commitfest.postgresql.org/action/commitfest_view?id=3 -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers