|
From: Nirmal S. <sha...@gm...> - 2014-01-31 23:38:37
|
Hi, I created a pgxc cluster with one coordinator, one GTM and 6 data nodes (all on same big machine ). To test the performance, i ran one query through coordinator on my data which is evenly distributed on all the nodes and it took total 25 sec to complete. And then i ran the same query on datanodes directly and it took 5 sec on each and every datanodes. Since query execution happens parallely on data nodes so ideally even if i run the query through coordinator, it should not take more than 5-8 sec max but i dont understand why is it taking 25 sec. Can somebody help me.? Do i need to make some changes to my cluster configuration? Regards Nirmal |