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

Поиск
Список
Период
Сортировка
От Alexander Korotkov
Тема [HACKERS] Is anything preventing us from allowing write to foreign tables from standby?
Дата
Msg-id CAPpHfdsbWaVabZ3xMAXp-OW0U=r7e1OD7MP2=_et+dDAWDqtDg@mail.gmail.com
обсуждение исходный текст
Ответы [HACKERS] Re: Is anything preventing us from allowing write to foreign tablesfrom standby?  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
Список 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
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Sokolov Yura
Дата:
Сообщение: Re: [HACKERS] Fix performance of generic atomics
Следующее
От: Yura Sokolov
Дата:
Сообщение: Re: [HACKERS] Walsender timeouts and large transactions