<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div style="RIGHT: auto"><SPAN style="RIGHT: auto">Thank you for your answer.</SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto">I installed the new version (2.1.1) and it is faster. </SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto">However I still have some delay, so I think that also some </SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto">configurations are necessary, as you suggested.</SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto">Thank you,</SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto"><VAR id=yui-ie-cursor></VAR></SPAN> </div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto">Laura</SPAN></div>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">
<DIV style="RIGHT: auto" dir=ltr><FONT size=2 face=Arial>
<DIV style="BORDER-BOTTOM: #ccc 1px solid; BORDER-LEFT: #ccc 1px solid; PADDING-BOTTOM: 0px; LINE-HEIGHT: 0; MARGIN: 5px 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; HEIGHT: 0px; FONT-SIZE: 0px; BORDER-TOP: #ccc 1px solid; BORDER-RIGHT: #ccc 1px solid; PADDING-TOP: 0px" class=hr contentEditable=false readonly="true"></DIV><B><SPAN style="FONT-WEIGHT: bold">Da:</SPAN></B> Steve Singer <ssinger@ca.afilias.info><BR><B><SPAN style="FONT-WEIGHT: bold">A:</SPAN></B> Laura Passigni <laurapassigni@yahoo.it> <BR><B><SPAN style="FONT-WEIGHT: bold">Cc:</SPAN></B> "slony1-general@lists.slony.info" <slony1-general@lists.slony.info> <BR><B><SPAN style="FONT-WEIGHT: bold">Inviato:</SPAN></B> Mercoledì 7 Marzo 2012 23:29<BR><B><SPAN style="FONT-WEIGHT: bold">Oggetto:</SPAN></B> Re: [Slony1-general] Slow sync<BR></FONT></DIV><BR>On 12-03-07 05:57 AM, Laura Passigni wrote:<BR>> Hi,<BR>> I have a big database (about 1350GB) with Slony replica (1
master and 1<BR>> slave).<BR>> Last week I have had a network crash between master and slave server.<BR>> Unfortunately there was a bulk import in progress in the master<BR>> database. As result the slave server was not in sync with the master for<BR>> few days.<BR>> There are now about 80.000 records in the sl_event table and the sync is<BR>> very slow. I have seen in the log file that the sync of each event<BR>> requires about 1500/2000 seconds. It is a very huge time.<BR>> Is there something that I can do? Is there some faster way to sync the<BR>> databases?<BR>> Thank you,<BR>> Laura<BR>> <BR><BR>It is possible that your issue is what we have been referring to as bug 167. This has been fixed in slony 2.1.0. What happens is that when sl_log_1 or sl_log_2 grows beyond a certain size the query turns into a sequential scan.<BR><BR>Other than upgrading, you need to push the sync interval up so you
generate fewer syncs, and increase the sync_groupsize so it processes more syncs together. This might allow slony to catch up. Once it is caught up your sl_log tables will get truncated and you can go back to normal settings/operations.<BR><BR><BR>> <BR>> <BR>> _______________________________________________<BR>> Slony1-general mailing list<BR>> <A href="mailto:Slony1-general@lists.slony.info" ymailto="mailto:Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</A><BR>> <A href="http://lists.slony.info/mailman/listinfo/slony1-general" target=_blank>http://lists.slony.info/mailman/listinfo/slony1-general</A><BR><BR><BR><BR></DIV></DIV></div></body></html>