Tom Lane wrote:
Nedyalko Borisov writes:
In summary, we are making two suggestions:
1. Extend the optimizer to consider joins between child tables when hierarchies
are joined together.
We already handle this for the case where the join is nestloop with
inner index scan, and I'
We've created some basic implementation, just to verify the benefits of these
ideas. The initial results seem promising as we observed decreased execution
time and for large data set the query execution time could be several times
faster than before.
We would greatly appreciate your comments, thoughts or suggestions that you
might have regarding these ideas.
Regards,
Nedyalko Borisov and Herodotos Herodotou
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers