[Postgres-xc-general] Looks like co-ordinator is my perf bottleneck....somebody help...

[Nirmal S. <sha...@gm...>]

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