Re: Streaming replication versus Logical replication

Поиск
Список
Период
Сортировка
Искать
От
Christophe Pettus
Тема
Re: Streaming replication versus Logical replication
Дата
Msg-id
55F01B76-E5A6-47DD-8247-47A5835F2CBA@thebuild.com
Ответ на
Список
Дерево обсуждения
Streaming replication versus Logical replication Alanoly Andrews <alanolya@invera.com>
Re: Streaming replication versus Logical replication Ninad Shah <nshah.postgres@gmail.com>
RE: Streaming replication versus Logical replication Alanoly Andrews <alanolya@invera.com>
Re: Streaming replication versus Logical replication Christophe Pettus <xof@thebuild.com>


> On Nov 4, 2021, at 12:16, Alanoly Andrews  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.

В списке pgsql-general по дате отправления
От: Alanoly Andrews
Дата:
От: Adrian Klaver
Дата:
FAQ