Re: Prepared transaction releasing locks before deregistering its GID

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Prepared transaction releasing locks before deregistering its GID
Дата
Msg-id 20190219115431.GX15532@paquier.xyz
обсуждение исходный текст
Ответ на Re: Prepared transaction releasing locks before deregistering its GID  (Oleksii Kliukin <alexk@hintbits.com>)
Список pgsql-hackers
Дерево обсуждения 
On Tue, Feb 19, 2019 at 10:59:33AM +0100, Oleksii Kliukin wrote:
> Michael Paquier <michael@paquier.xyz> wrote:
>> If you run two transactions in parallel using your script, the second
>> transaction would wait at LOCK time until the first transaction
>> releases its locks with the COMMIT PREPARED.
>
> That is the desired outcome, right?

Yes, that is the correct one in my opinion, and we should not have GID
conflicts when running the scenario you provided upthread.
--
Michael
Вложения

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

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: Protect syscache from bloating with negative cache entries
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: Speed up transaction completion faster after many relations areaccessed in a transaction