Hi,

I try to help my server to work better ^^

I have all the time this in my log 

2015-01-09 12:05:25 CET [11969]: [8-1] user=slony,db=RPP2,remote=127.0.0.1(33237) LOG:  duration: 2202.807 ms  statement: insert into "_repli_local116".sl_event     (ev_origin, ev_seqno, ev_timestamp,      ev_snapshot, ev_type     ) values ('116', '5000282096', '2015-01-09 12:04:35.116816+01', '70712675:70712675:', 'SYNC'); insert into "_repli_local116".sl_confirm   (con_origin, con_received, con_seqno, con_timestamp)    values (116, 1, '5000282096', now()); commit transaction;
2015-01-09 12:06:41 CET [12154]: [12-1] user=slony,db=RPP2,remote=127.0.0.1(33311) LOG:  duration: 2344.793 ms  statement: commit transaction;

I don't know why my server take too much time to insert lines ! 

-----Message d'origine-----
De : Stéphane Schildknecht [mailto:stephane.schildknecht at postgres.fr] 
Envoyé : jeudi 8 janvier 2015 16:31
À : Sebastien Marchand; 'Glyn Astill'; 'Vick Khera'
Cc : 'slony'
Objet : Re: [Slony1-general] too much work !

On 08/01/2015 16:18, Sebastien Marchand wrote:
> Thx for your answer, i will look this, never saw in action.
> 

Could you give us a more information of the problem you're trying to solve ?

S.
--
Stéphane Schildknecht
Contact régional PostgreSQL pour l'Europe francophone Loxodata - Conseil, expertise et formations