[HACKERS] Re: Is anything preventing us from allowing write to foreign tablesfrom standby?

Поиск
Список
Период
Сортировка
От Alexander Korotkov
Тема [HACKERS] Re: Is anything preventing us from allowing write to foreign tablesfrom standby?
Дата
Msg-id CAPpHfdtSrnZkQ4PHG6i_tx_15tnu5e-jdTyTdpV3Xo00FsffoA@mail.gmail.com
обсуждение исходный текст
Ответ на [HACKERS] Is anything preventing us from allowing write to foreign tables from standby?  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
Ответы Re: [HACKERS] Re: Is anything preventing us from allowing write toforeign tables from standby?  (Craig Ringer <craig@2ndquadrant.com>)
Список pgsql-hackers
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Jeevan Chalke
Дата:
Сообщение: Re: [HACKERS] Partition-wise aggregation/grouping
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: [HACKERS] Determine state of cluster (HA)