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

[Mason S. <ms...@tr...>]

On Sat, Feb 1, 2014 at 11:46 AM, Nirmal <sha...@gm...> wrote:

> Hi Koichi,
>
> My tables are not replicated. They all are distributed the way you
> explained.
> For example, total record in one table is 600000 and i have 6 nodes so
> each and every node has got 100000 records.
>
> Now the issue is that when I am running my query directly on data node it
> comes up in 5 sec and it is taking the same time on each and every node so
> it should take the same time if i run the query through coordinator but
> somehow instead on 5sec it's taking 22 sec. So somehow the query execution
> on nodes are happening correctly but data movement from nodes to
> coordinator is taking a lot of time.
>
>


> Please advise.
>
>
What does your query look like? A single table? A join? Using aggregates?

Thanks,

Mason