Postgres Pro
Downloads
Home   >   mailing lists

[HACKERS] Re: Is anything preventing us from allowing write to foreign tablesfrom standby? - Mailing list pgsql-hackers

From Alexander Korotkov
Subject [HACKERS] Re: Is anything preventing us from allowing write to foreign tablesfrom standby?
Date
Msg-id CAPpHfdtSrnZkQ4PHG6i_tx_15tnu5e-jdTyTdpV3Xo00FsffoA@mail.gmail.com
Whole thread Raw
In response to [HACKERS] Is anything preventing us from allowing write to foreign tables from standby?  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
Responses Re: [HACKERS] Re: Is anything preventing us from allowing write toforeign tables from standby?
List pgsql-hackers
Tree view
On Wed, Sep 6, 2017 at 4:42 PM, Alexander Korotkov <a.korotkov@postgrespro.ru> wrote:
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.

No interest yet, but no objections too :-)
I'm going to add this to next commitfest.

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

pgsql-hackers by date:

Previous
From: Jeevan Chalke
Date:
Subject: Re: [HACKERS] Partition-wise aggregation/grouping
Next
From: "Joshua D. Drake"
Date:
Subject: Re: [HACKERS] Determine state of cluster (HA)