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