Re: Read-only access to temp tables for 2PC transactions

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Read-only access to temp tables for 2PC transactions
Дата
Msg-id CANP8+jJiSqRL5D+EAGGtkptj4rg-JB9+mKkr6VVhYrH7CB7XWA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Read-only access to temp tables for 2PC transactions  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Дерево обсуждения
On Thu, 23 May 2019 at 16:55, Andres Freund <andres@anarazel.de> wrote:
Hi,

On 2019-05-23 12:36:09 +0100, Simon Riggs wrote:
> The ONLY case where this matters is if someone does a PREPARE and then
> starts doing other work on the session. Which makes no sense in the normal
> workflow of a session. I'm sure there are tests that do that, but those
> tests are unrepresentative of sensible usage.

That's extremely common.

Not at all.
 
There's no way we can forbid using session after 2PC unconditionally,
it'd break most users of 2PC.

Since we disagree, can you provide more information about this usage pattern? 

--
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: Why does not subquery pruning conditions inherit to parent query?
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Read-only access to temp tables for 2PC transactions