Re: data consolidation: logical replication design considerations

From: Rory Campbell-Lange <rory(at)campbell-lange(dot)net>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: data consolidation: logical replication design considerations
Date: 2022-07-23 08:40:23
Message-ID: Ytuz97ao+5iIwomc@campbell-lange.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 16/07/22, Rory Campbell-Lange (rory(at)campbell-lange(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message James Pang (chaolpan) 2022-07-26 08:53:29 alter table xxx set unlogged take long time
Previous Message bruno da silva 2022-07-21 20:37:23 Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries