Logical Replication - Give One Subscription Priority Over Other Subscriptions

From: Avi Weinberg <AviW(at)gilat(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Logical Replication - Give One Subscription Priority Over Other Subscriptions
Date: 2022-09-18 07:08:48
Message-ID: DB9PR07MB7180DFCDE383DB50A3F12FE9CB4A9@DB9PR07MB7180.eurprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I use logical replication to synchronize one big table + some small tables.

I know that if all tables are part of the same subscription it will be executed in transactional order. In other words, as long as the transaction that updated the big table is not synchronized and executed on the subscriber side, no other transactions to the smaller tables will be synchronized to the subscriber side. Therefore, I split it into two subscriptions, one for the big table and another for the smaller tables.

* How can I give higher priority to the subscription that synchronizing the smaller tables over the subscription that synchronizes the large table?
* If that is not possible, how do I make sure the subscription that synchronizes the big table does not "starve" the subscription that synchronizes the small tables and leave it with almost no bandwidth?

Thanks!

IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.

Browse pgsql-general by date

  From Date Subject
Next Message Matthias Apitz 2022-09-18 09:30:40 Re: Mysterious performance degradation in exceptional cases
Previous Message Adrian Klaver 2022-09-17 21:41:26 Re: get user info on log