Search Postgresql Archives

Re: Streaming replication versus Logical replication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




> On Nov 4, 2021, at 12:16, Alanoly Andrews <alanolya@xxxxxxxxxx> wrote:
> 
> Thanks, Ninad, for the response.
> So, am I to understand that when there is a long-running query on the subscriber, the vacuumed data updates from the publisher are held over on the subscriber until the query completes? If so, where and how are they held over, and what does it mean in terms of disk space (either on the publisher or on the subscriber)?

That's not quite correct.

Vacuum operations happen independently on the publisher and subscriber in logical replication.  Unlike binary replication, changes caused by vacuuming on the publisher are not sent over to the subscriber.





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux