> I'd like to throw community folks a question. > Did someone have a discussion to the challenge of aggregate push-down across > relations join in the past? It potentially reduces number of rows to be joined. > If we already had, I'd like to check up the discussion at that time.
Yes, I was looking at aggregate pushdown. I think it needs the same changes to aggregates discussed upthread.
I have something that I've been working on locally. It's far from ready, but it does work in very simple cases, and shows a nice performance boost. I'll start another thread soon and copy you both in. Perhaps we can share some ideas.