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

[Ashutosh B. <ash...@en...>]

Sandeep,
It would be nice if you mention the version of XC in your mail. Sort push
down is available from 1.1 onwards. If you do not see sort getting pushed
down in 1.1, please report detailed definitions of the tables, query and
the EXPLAIN output.


On Thu, Oct 17, 2013 at 1:09 AM, Sandeep Gupta <gup...@gm...>wrote:

> 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
>
>
>
>
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
> from
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>
>


-- 
Best Wishes,
Ashutosh Bapat
EnterpriseDB Corporation
The Postgres Database Company