| 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 |
| 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 |