Re: data consolidation: logical replication design considerations - Mailing list pgsql-performance

From Rory Campbell-Lange
Subject Re: data consolidation: logical replication design considerations
Date
Msg-id Ytuz97ao+5iIwomc@campbell-lange.net
Whole thread Raw
In response to data consolidation: logical replication design considerations  (Rory Campbell-Lange <rory@campbell-lange.net>)
List pgsql-performance
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



pgsql-performance by date:

Previous
From: bruno da silva
Date:
Subject: Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries
Next
From: "James Pang (chaolpan)"
Date:
Subject: alter table xxx set unlogged take long time