Re: [Postgres-xc-general] gtm_problem_and_slow_write

[鈴木 幸市 <ko...@in...>]

Message 1. will be written once every 2000 transactions.    The number looks too large.   Message 1 is written in the three cases:

1) When GTM starts,
2) Once every 2000 transactions,
3) When GTM standby is promoted to a master.

Could you let me know how you start your cluster?    We’ve tested XC with DBT-1 and DBT-2 but didn’t have such frequent write at gtm.   You are inserting 5000 raws in a second so 2) should happen twice or three times a second.

Message 2. is written when GTM standby connects to GTM.   Are you using GTM standby?   If so, how you are starting it?

We’re testing XC in different environment but didn’t have such GTM overload.   I’m interested in the situation.

Best;
---
Koichi Suzuki

2013/11/09 0:06、Matej Jellus <je...@ts...> のメール：

> Hello,
> 
> We have problem that postgres xc is very slow, gtm is writing to log a 
> lot of data. Is it able to be disabled?
> The most repeated lines are :
> 
> 1:140130870839040:2013-11-08 15:42:49.357 CET -LOG:  Saving transaction 
> restoration info, backed-up gxid: 373106
> LOCATION:  GTM_WriteRestorePointXid, gtm_txn.c:2649
> ( this is maybe 130 times per second )
> 
> 1:140130879186688:2013-11-08 15:45:37.572 CET -LOG:  Connection 
> established with GTM standby. - 0x1f91398
> LOCATION:  gtm_standby_connect_to_standby_int, gtm_standby.c:400
> 
> It is overloading the disk, i/o is 70%.
> 
> Now it is inserting 5 thousand inserts per minute. We need more inserts 
> per minute.
> 
> Thank you, best regards
> Matej
> 
> ------------------------------------------------------------------------------
> November Webinars for C, C++, Fortran Developers
> Accelerate application performance with scalable programming models. Explore
> techniques for threading, error checking, porting, and tuning. Get the most 
> from the latest Intel processors and coprocessors. See abstracts and register
> http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>