Sure, but aggregating as early as possible will often have the effect of dramatically reducing the number of tuples that have to pass through upper levels of the plan tree, which seems it would frequently far outweigh those considerations.
Agreed
I can imagine plans where a useful aggregation occurs before every join, so N > 2 is easily possible.
--
Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services