Re: Logical Replication of sequences
| От | Chao Li |
|---|---|
| Тема | Re: Logical Replication of sequences |
| Дата | |
| Msg-id | EF974C92-438B-47E9-822E-9C46254AC7B2@gmail.com обсуждение исходный текст |
| Ответ на | Re: Logical Replication of sequences (vignesh C <vignesh21@gmail.com>) |
| Ответы |
Re: Logical Replication of sequences
|
| Список | pgsql-hackers |
Hi Vignesh, A few more comments: > On Nov 7, 2025, at 22:47, vignesh C <vignesh21@gmail.com> wrote: > > The attached v20251107_2 version patch has the changes for the same. > > Regards, > Vignesh > <v20251107_2-0001-Documentation-for-sequence-synchronizati.patch> 1 ``` - Currently, there can be only one synchronization worker per table. + Currently, there can be only one table synchronization worker per table + and one sequence synchronization worker to synchronize all sequences. ``` Feels like this statement is not accurate and leaves an impression that a table has a fixed work to serve it. So I thinkwe can enhance this statement a little bit as: ``` Currently, only one table synchronization worker runs per table, and only one sequence synchronization worker runs per subscription at a time. ``` 2 ``` +<programlisting> +/* sub # */ CREATE SEQUENCE s1 START WITH 10 INCREMENT BY 1 +/* sub # */ CREATE SEQUENCE s2 START WITH 100 INCREMENT BY 10; +</programlisting></para> ``` Missed semi-colon for the first SQL statement. 3 ``` +<programlisting> +/* sub # */ SELECT srrelid::regclass, srsublsn FROM pg_subscription_rel ; ``` Unneeded white-space before the semi-colon. 4 ``` +/* sub # */ SELECT * FROM s2 + last_value | log_cnt | is_called +------------+---------+----------- + 610 | 0 | t +(1 row) ``` Again, missed semi-colon. Best regards, -- Chao Li (Evan) HighGo Software Co., Ltd. https://www.highgo.com/
В списке pgsql-hackers по дате отправления: