| From: | Rory Campbell-Lange <rory(at)campbell-lange(dot)net> |
|---|---|
| To: | Robert Blayzor <rblayzor(dot)bulk(at)inoc(dot)net> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: PgSQL 14 - Logical Rep - Single table multiple publications? |
| Date: | 2022-08-02 19:18:16 |
| Message-ID: | Yul4eKzx++b9YJV7@campbell-lange.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 02/08/22, Robert Blayzor (rblayzor(dot)bulk(at)inoc(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ameya Bidwalkar | 2022-08-03 11:05:25 | Re: Postgresql 13 partitioning advice |
| Previous Message | Tom Lane | 2022-08-02 19:14:39 | Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries |