Postgres Pro
Downloads
Home   >   mailing lists

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

From Alexander Korotkov
Subject [HACKERS] Is anything preventing us from allowing write to foreign tables from standby?
Date
Msg-id CAPpHfdsbWaVabZ3xMAXp-OW0U=r7e1OD7MP2=_et+dDAWDqtDg@mail.gmail.com
Whole thread Raw
Responses [HACKERS] Re: Is anything preventing us from allowing write to foreign tablesfrom standby?  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
List pgsql-hackers
Tree view
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

pgsql-hackers by date:

Previous
From: Sokolov Yura
Date:
Subject: Re: [HACKERS] Fix performance of generic atomics
Next
From: Yura Sokolov
Date:
Subject: Re: [HACKERS] Walsender timeouts and large transactions