<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi Lucas, what is the size of the data you are syncing ? I see 211 tables in total, and, do you have an estimation of the size you are moving?.<div class=""><br class=""></div><div class="">I’ve been working on how bucardo scale in different scenarios of data size, as number of registers, tables and size of the syncing.</div><div class=""><br class=""></div><div class="">In order to know more in depth I recommend you to check bucado DB tables (psql -U bucardo): sync and syncrun in both bucardo instances and paste here (sorted by started DESC field) the first registers. In syncrun tables you will see the delay and the status of the transaction, etc.</div><div class=""><br class=""></div><div class="">Let me know if you have this information.</div><div class=""><br class=""></div><div class="">Cheers,</div><div class="">Manu.</div><div class=""><br class=""></div><div class=""><div><br class=""><blockquote type="cite" class=""><div class="">On 16 Nov 2021, at 02:37, Lucas Possamai <<a href="mailto:drum.lucas@gmail.com" class="">drum.lucas@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class=""><div class="">Hi,</div><div class="">I've setup a replication between PG 9.2 and PG 14 for a migration. I noticed that the replication is quite delayed, and was wondering if I missed something, or if it's just the way Bucardo works?</div><div class=""><br class=""></div><div class="">Below you can see a screenshot of the same query being run in PG 14 via Bucardo (<b class="">left</b>) and PG 9.2 streaming replication slave (<b class="">right</b>):</div><div class=""><span id="cid:ii_kw1f61ra0"><Screen Shot 2021-11-16 at 2.26.39 PM.png></span><br class=""></div><div class="">Notice that Bucardo is quite behind. Is that expected? Can't I improve that somehow?</div><div class=""><br class=""></div><div class=""><span id="cid:ii_kw1fcfni2"><Screen Shot 2021-11-16 at 2.34.58 PM.png></span><br class=""></div><div class="">Bucardo status looks okay.<br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><b class="">Some extra information:</b></div><div class="">------------------------------------------------------------------------</div><div class=""><br class=""></div><div class="">master --> slave01 (Postgres 9.2 streaming replication)</div><div class=""> --> slave02 (Postgres 9.2 streaming replication)</div><div class=""> --> slave03 (Postgres 9.2 streaming replication)</div><div class=""> --> slave04 (Postgres 9.2 streaming replication)<br class=""></div><div class=""> --> Bucardo --> PG 14<br class=""></div><div class=""><br class=""></div><div class="">------------------------------------------------------------------------</div><div class=""><br class=""></div><div class="">Thanks</div><div class="">Lucas<br class=""></div></div>
_______________________________________________<br class="">Bucardo-general mailing list<br class=""><a href="mailto:Bucardo-general@bucardo.org" class="">Bucardo-general@bucardo.org</a><br class="">https://bucardo.org/mailman/listinfo/bucardo-general<br class=""></div></blockquote></div><br class=""></div></body></html>