@vogievetsky pointed out to me that it's possible to push down ordering + limits if you're sorting on the grouping tuple. This is because any tuple in the first N results overall is going to either be somewhere in the first N results from each segment, or not in that segment at all.
@vogievetsky pointed out to me that it's possible to push down ordering + limits if you're sorting on the grouping tuple. This is because any tuple in the first N results overall is going to either be somewhere in the first N results from each segment, or not in that segment at all.