Re: [Postgres-xc-developers] A question on DBT1 performance

[xiong w. <wan...@gm...>]

Hi Mason,

I tested it by 5 PCs.

The enviroment as follows:

2 PCs,  one datanode and one coordinator together on each of them,
GTM is on another PC,
2 Loaders are on other 2 PCs.
Network 1G.


 I tested Postgres-XC in two methods as follows:

Method 1.

loader -------- coordinator & datanode
                                                     \
                                                         GTM
                                                     /
loader -------- coordinator & datanode


Method 2.
loader-------- coordinator & datanode
          \      /                                    \
            \  /                                        \
             /\                                             GTM

           /   \                                         /
         /       \                                     /
loader -------- coordinator & datanode


The DBT1 test results in these two methods are very different. Method 1 is
much better than Method 2. I don't know why.

If I test Postgres-XC in Method 1, the DBT1 performance is close to what
the document declares. If I test it in Method 2, the result is much worse
than what the document writes. Could you tell me why the two methods have so
much effect on the DBT1 performace.

Thanks,

Regards,
Benny

>How much worse?

>How many physical servers are in each configuration? How is each server
>configured in each, with how many data nodes? What kind of network?
>Gigabit?

>Or was everything on one system? With virtual machines or without and
>just using different ports?

>Are there errors in the log file (connection limits hit)?

>Regards,

>Mason