Re: PgSQL 14 - Logical Rep - Single table multiple publications?

Поиск
Список
Период
Сортировка
От Rory Campbell-Lange
Тема Re: PgSQL 14 - Logical Rep - Single table multiple publications?
Дата
Msg-id Yul4eKzx++b9YJV7@campbell-lange.net
обсуждение исходный текст
Ответ на Re: PgSQL 14 - Logical Rep - Single table multiple publications?  (Robert Blayzor <rblayzor.bulk@inoc.net>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries
Следующее
От: Ameya Bidwalkar
Дата:
Сообщение: Re: Postgresql 13 partitioning advice