Is anything preventing us from allowing write to foreign tables from standby?

From: Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Is anything preventing us from allowing write to foreign tables from standby?
Date: 2017-09-06 13:42:49
Message-ID: CAPpHfdsbWaVabZ3xMAXp-OW0U=r7e1OD7MP2=_et+dDAWDqtDg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi!

We're currently blocking writing queries on standby if even they are
modifying contents of foreign tables. But do we have serious reasons for
that?
Keeping in the mind FDW-sharding, making FDW-tables writable from standby
would be good to prevent single-master bottleneck.
I wrote simple patch enabling writing to foreign tables from standbys. It
works from the first glance for me.

------
Alexander Korotkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

Attachment Content-Type Size
standby-fdw-writable.patch application/octet-stream 480 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Yura Sokolov 2017-09-06 13:46:16 Re: Walsender timeouts and large transactions
Previous Message Sokolov Yura 2017-09-06 13:42:29 Re: Fix performance of generic atomics