Hi, 18 nodes, wan network. 2 replications ( one with 1 set and other with 2 sets ( 2 directions ) ) First replication from server 1 to n servers ( same schema, 37 tables ) 1 slon on server 1 and 1 slon by remote server Second replication : set 1 : server A -> server 1 ( 90 replicated tables ) set 2 : server A <- server 1 ( 1 replicated tables ) do the same with 17 other servers ( one schema by server ) 17 slons on server 1 and 1 slon by remote server database 5 gB.
I don't know if that will help... -----Message d'origine----- De : Stéphane Schildknecht [mailto:stephane.schildkne...@postgres.fr] Envoyé : vendredi 9 janvier 2015 15:01 À : Sebastien Marchand; 'Glyn Astill'; 'Vick Khera' Cc : 'slony' Objet : Re: [Slony1-general] too much work ! 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 _______________________________________________ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general
