[prev in list] [next in list] [prev in thread] [next in thread]
List: pgsql-performance
Subject: Re: data consolidation: logical replication design considerations
From: Rory Campbell-Lange <rory () campbell-lange ! net>
Date: 2022-07-23 8:40:23
Message-ID: Ytuz97ao+5iIwomc () campbell-lange ! net
[Download RAW message or body]
On 16/07/22, Rory Campbell-Lange (rory@campbell-lange.net) wrote:
> I'd be grateful for some comments on the advisability of using a large
> number of concurrent logical replication publications/subscriptions.
> Below I've set out the current environment and a suggested design.
> Apologies for the length of this email.
...
> * to avoid overloading the existing primary host with many replication
> slots, it would be wise to implement aggregation on another host
Looking into this further it appears that a streaming replication secondary can
not act as a logical replication publisher. Is that correct?
Rory
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic