Postgres Pro
Downloads
Home   >   mailing lists

Re: what happens if a failed transaction is not rolled back? - Mailing list pgsql-general

From David Wheeler
Subject Re: what happens if a failed transaction is not rolled back?
Date
Msg-id 5AE892DD-A808-4874-AAD4-C47E5C92E28D@gmail.com
Whole thread Raw
In response to Re: what happens if a failed transaction is not rolled back?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view


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 by date:

Previous
From: Max Kremer
Date:
Subject: Fwd: postgresql15-contrib installation on Amazon Linux 2 fails on Python shared lib dependency
Next
From: "David G. Johnston"
Date:
Subject: Re: what happens if a failed transaction is not rolled back?