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

[Michael P. <mic...@gm...>]

>
>
>
>>
>> I can also see in your results that method 1 is using in total 2
>> connections between the loaders and coordinators.
>> Method 2 is using 4 connections.
>> I think you did so but... Did you include for method 2 the results of
>> loader1-coordinator1 + loader1-coordinator2 for loader1 results?
>> Same for loader2?
>>
> As I know one loader can get one DBT1 result. As you told, a coordinator
> should get one DBT1 result beacuse you said I should use
> loader1-coordinator1 + loader1-coordinator2 as the result of method2. I don'
> t know how can I get DBT1 results according to coordinator.
>
>
If you use one DBT-1 folder for two instances to coordinators from a loader,
both instances try to write at the same time in the same mix.log, what could
result in a loss of data.
Why not separating the instances by launching each loaderX-coordinatorX
instance in a different DBT-1 folder?
In the case of method 2, create 2 DBT-1 folders on each loader server, for a
total of 4 folders.
You will have 4 mix.log file for the output of:
- loader1/coordinator1
- loader1/coordinator2
- loader2/coordinator1
- loader2/coordinator2

If you do that, you have just to combine mix.log files of
loader2/coordinator1 and loader2/coordinator2 to get the output of a loader
2 for instance.
It may be also interesting to get the output from Coordinator 1 and 2, by
combining for instance log files of loader1/coordinatorX and
loader2/coordinatorX.

-- 
Michael Paquier
http://michaelpq.users.sourceforge.net