Re: what happens if a failed transaction is not rolled back?

Поиск
Список
Период
Сортировка
От David Wheeler
Тема Re: what happens if a failed transaction is not rolled back?
Дата
Msg-id 5AE892DD-A808-4874-AAD4-C47E5C92E28D@gmail.com
обсуждение исходный текст
Ответ на Re: what happens if a failed transaction is not rolled back?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Дерево обсуждения


On 25 Apr 2023, at 1:47 am, David G. Johnston <david.g.johnston@gmail.com> wrote:

There isn't anything special about a failed transaction compared to any other transaction that you leave open.

Now I’m curious. Does it have the same impact on performance that an idle in transaction connection has? Eg does it prevent vacuum? Does it still hold locks?

David

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

Предыдущее
От: Max Kremer
Дата:
Сообщение: Fwd: postgresql15-contrib installation on Amazon Linux 2 fails on Python shared lib dependency
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: what happens if a failed transaction is not rolled back?