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

From: David Wheeler <hippysoyboy(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Siddharth Jain <siddhsql(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: what happens if a failed transaction is not rolled back?
Date: 2023-04-24 19:56:22
Message-ID: 5AE892DD-A808-4874-AAD4-C47E5C92E28D@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On 25 Apr 2023, at 1:47 am, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2023-04-24 20:24:06 Re: what happens if a failed transaction is not rolled back?
Previous Message Max Kremer 2023-04-24 19:50:28 Fwd: postgresql15-contrib installation on Amazon Linux 2 fails on Python shared lib dependency