[Bucardo-general] Bucardo replication delay

[ManuParra]

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?.

I’ve been working on how bucardo scale in different scenarios of data size, as number of registers, tables and size of the syncing.

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.

Let me know if you have this information.

Cheers,
Manu.


> On 16 Nov 2021, at 02:37, Lucas Possamai <drum.lucas at gmail.com> wrote:
> 
> Hi,
> 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?
> 
> Below you can see a screenshot of the same query being run in PG 14 via Bucardo (left) and PG 9.2 streaming replication slave (right):
> <Screen Shot 2021-11-16 at 2.26.39 PM.png>
> Notice that Bucardo is quite behind. Is that expected? Can't I improve that somehow?
> 
> <Screen Shot 2021-11-16 at 2.34.58 PM.png>
> Bucardo status looks okay.
> 
> 
> Some extra information:
> ------------------------------------------------------------------------
> 
> master --> slave01 (Postgres 9.2 streaming replication)
>             --> slave02 (Postgres 9.2 streaming replication)
>             --> slave03 (Postgres 9.2 streaming replication)
>             --> slave04 (Postgres 9.2 streaming replication)
>             --> Bucardo --> PG 14
> 
> ------------------------------------------------------------------------
> 
> Thanks
> Lucas
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://bucardo.org/mailman/listinfo/bucardo-general

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20211116/33adfbb9/attachment.htm>