[Bucardo-general] Bucardo replication delay

Lucas Possamai drum.lucas at gmail.com
Tue Nov 16 01:37:05 UTC 2021


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*):
[image: 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?

[image: 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20211116/87c8af24/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screen Shot 2021-11-16 at 2.26.39 PM.png
Type: image/png
Size: 49065 bytes
Desc: not available
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20211116/87c8af24/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screen Shot 2021-11-16 at 2.34.58 PM.png
Type: image/png
Size: 100792 bytes
Desc: not available
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20211116/87c8af24/attachment-0003.png>


More information about the Bucardo-general mailing list