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
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
