Re: Libpq support to connect to standby server as priority

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Libpq support to connect to standby server as priority
Дата
Msg-id 26890.1542047012@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Libpq support to connect to standby server as priority  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: Libpq support to connect to standby server as priority  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-hackers
Laurenz Albe <laurenz.albe@cybertec.at> writes:
> Haribabu Kommi wrote:
>> Added comments along the lines that you mentioned. And also try
>> to update some more comments.

> Looks ok to me, I'll mark it as "ready for committer".

I don't like this patch at all: the business with keeping two connections
open seems impossibly fragile and full of race conditions.  (For instance,
by the time you return the read-only session to the application, it might
not be read-only any more.  I also wonder what inquiry functions like
PQsocket ought to return while in this state.)  I think the feature
definition needs to be re-thought to make that unnecessary.

Also, we really need to consider the interaction between this and the
feature(s) being discussed in the thread at

https://www.postgresql.org/message-id/flat/1700970.cRWpxnom9y%40hammer.magicstack.net

            regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] [PATCH v2] Add and report the new "session_read_only" GUC pseudo-variable.
Следующее
От: Jeremy Finzel
Дата:
Сообщение: Race condition in WaitForBackgroundWorkerStartup