Hi, there has been discussion at the logical replication initial copy thread [1] about making apply work with sync commit off by default for performance reasons and adding option to change that per subscription.
Here I propose patch to implement this - it adds boolean column subssynccommit to pg_subscription catalog which decides if synchronous_commit should be off or local for apply. And it adds SYNCHRONOUS_COMMIT = boolean to the list of WITH options for CREATE and ALTER SUBSCRIPTION. When nothing is specified it will set it to false. The patch is built on top of copy patch currently as there are conflicts between the two and this helps a bit with testing of copy patch. [1] https://www.postgresql.org/message-id/CA+TgmoY7Lk2YKArcp4O=Qu=xoor8j71mad1oteojawmuje3...@mail.gmail.com -- Petr Jelinek http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
Add-option-to-modify-sync-commit-per-subscription.patch
Description: binary/octet-stream
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
