On 09/01/2015 12:10, Sebastien Marchand wrote:
> 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 ! 
> 


Could you explain your architecture.
Nodes, sets, tables, connections between nodes, directions of the flows...
Size of the tables/database...

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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 490 bytes
Desc: OpenPGP digital signature
Url : http://lists.slony.info/pipermail/slony1-general/attachments/20150109/b9305df3/attachment.pgp