Re: [Postgres-xc-developers] Fixing pgbench bug

[坂田 哲夫 <sak...@la...>]

Suzuki-san,

Thank you for your quick response.

I quickly checked pgbench included in XC 1.0.3 to find
this version does not have the problem I pointed out before.

So, you don't need apply that patch to the pgbench in XC 1.0.3.

** additional correction **

The patch I posted before does not have some corrections
for messages about "-k" option.
Now I send a newly created patch to supersede the predecessor.

Best Regards,

Tetsuo Sakata.


(2014/03/05 15:54), 鈴木 幸市 wrote:
> Sakata-san;
> 
> Thank you very much for the fix.    The patch looks to be applicable to 1.0..x as well.   Please let me know your thought.
> 
> Regards;
> ---
> Koichi Suzuki
> 
> 2014/03/05 15:23、坂田　哲夫 <sak...@la...> のメール：
> 
>> Hi, folks,
>>
>> I found a pgbench bug that pgbench fails to update tables such as
>> pgbench_accounts and pgbench_tellers.
>>
>> For example, original pgbench for XC tries to update pgbench_accounts'
>> specifying aid and bid values which are selected independently.
>> By the pgbench's nature, bid should have a particular value for a
>> given aid value. So the update statement fails picking up target
>> tuple and updating the table in most cases.
>>
>> The attached patch, which should be applied to XC 1.1s
>> pgbench, eliminates wrongly added bid specifications
>> and corrects index and distribute settings related.
>>
>> Best regards,
>>
>> Tetsuo Sakata.
>>
>> -- 
>> sakata.tetsuo _at_ lab.ntt.co.jp
>> SAKATA, Tetsuo. Shinagawa Tokyo JAPAN.
>> <pgbench_20140305.patch>------------------------------------------------------------------------------
>> Subversion Kills Productivity. Get off Subversion & Make the Move to Perforce.
>> With Perforce, you get hassle-free workflows. Merge that actually works.
>> Faster operations. Version large binaries.  Built-in WAN optimization and the
>> freedom to use Git, Perforce or both. Make the move to Perforce.
>> http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg..clktrk_______________________________________________
>> Postgres-xc-developers mailing list
>> Pos...@li...
>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
> 
> 
> ------------------------------------------------------------------------------
> Subversion Kills Productivity. Get off Subversion & Make the Move to Perforce.
> With Perforce, you get hassle-free workflows. Merge that actually works.
> Faster operations. Version large binaries.  Built-in WAN optimization and the
> freedom to use Git, Perforce or both. Make the move to Perforce.
> http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
> 


-- 
sakata.tetsuo _at_ lab.ntt.co.jp
SAKATA, Tetsuo. Shinagawa Tokyo JAPAN.