[Postgres-xc-general] pushing order by clause to datanodes

[Sandeep G. <gup...@gm...>]

Hi,

 In an another query that requires the result to be aggregated and ordered
by a field (lets say timeo)
the query planner currently pulls  the results and then performs a sort
with hash aggregate.

The table at the datanodes are clustered by timeo. I was wondering if it
possible
for query planner to push down the order by clause at the datanode and then
perform
sort-merge aggregate at the coordinator. Surely, that would be a better
query plan.

We have tried enable_sort=off etc. but that doesn't work.

Thanks.
Sandeep