Re: [Postgres-xc-general] Data Node Scan Performance

[amul s. <sul...@ya...>]

On Tuesday, 29 April 2014 10:58 AM, Aaron Jackson <aja...@re...> wrote: 
Interesting, 

>Any thoughts - is it completely attributed to the coordinator? 
I am not sure, but in your example, MyTable is distributed on foo and search on ID, if somehow you able to add distribution key search in WHERE condition (eg. ....WHERE Id = 186 AND Foo=xyz ), planner would get help to locate candidate tuple easily. 
Current situation it scanning all the datanodes & combine result at coordinator. 
Dose ID is unique in MyTable ? if so can't you can distribute on ID? 
Regards, 
Amul Sul