Re: PgSQL 14 - Logical Rep - Single table multiple publications? - Mailing list pgsql-performance

From Rory Campbell-Lange
Subject Re: PgSQL 14 - Logical Rep - Single table multiple publications?
Date
Msg-id Yul4eKzx++b9YJV7@campbell-lange.net
Whole thread Raw
In response to Re: PgSQL 14 - Logical Rep - Single table multiple publications?  (Robert Blayzor <rblayzor.bulk@inoc.net>)
List pgsql-performance
On 02/08/22, Robert Blayzor (rblayzor.bulk@inoc.net) wrote:
> On 8/2/22 10:57, Rory Campbell-Lange wrote:
> > Special care must be taken with the "replica identity" of published
> > tables, as set out at
> > https://www.postgresql.org/docs/current/logical-replication-publication.html.
> 
> We would literally just be merging bulk data rows that are considered
> immutable, meaning they would never be updated or deleted. We would
> replicate only inserts, not deletes, updates, etc.
> 
> Would the table identifier still be required in this case?

On the page referenced above is the following:

"INSERT operations can proceed regardless of any replica identity."

So you should be good.

Rory



pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries
Next
From: Ameya Bidwalkar
Date:
Subject: Re: Postgresql 13 partitioning advice