Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pr2Ik-0003vd-4T for pgsql-general@arkaria.postgresql.org; Mon, 24 Apr 2023 19:56:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pr2Ii-0007EA-3e for pgsql-general@arkaria.postgresql.org; Mon, 24 Apr 2023 19:56:40 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pr2Ih-0007E1-OS for pgsql-general@lists.postgresql.org; Mon, 24 Apr 2023 19:56:39 +0000 Received: from mail-pf1-x433.google.com ([2607:f8b0:4864:20::433]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1pr2If-001gWJ-F6 for pgsql-general@lists.postgresql.org; Mon, 24 Apr 2023 19:56:38 +0000 Received: by mail-pf1-x433.google.com with SMTP id d2e1a72fcca58-63b67a26069so6640301b3a.0 for ; Mon, 24 Apr 2023 12:56:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1682366196; x=1684958196; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=eCt2JQ+tfgfhG5GNfhqfCSXL80y/PHFDamHpB8Z99uE=; b=Oqyz8ygXPXjQ+pt4vQ3871FokmCpCw0/DXNO9iOjZNE4hqKI4F7HKYWYLqbC8RJzOF cBEXNOKI4jyNHgrPmM+HlDqga4UcmyJiDDx+jVfhtYTLiOKBOEtwBXEq2UY/uQ4YVRVs 2WbW7MIwmGPNtPGkLIiVrzG3xLNlOtyqdz0cP0H2BocUBJHux5dNpxvo4E5kzvnBZ8N0 r+D+5NZFFIyOTPeVnNM4tXBrPlY5OGNd05v3cKGVpMRgaJG9zTr9j8qGrERSfnJR/ETp zZeAqxarMemV2SZcbgR2GOCSk1KiynzaSKL+hj5DT3L1f02yW3ouY1kXBb3TtRHHGZ1J llig== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1682366196; x=1684958196; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=eCt2JQ+tfgfhG5GNfhqfCSXL80y/PHFDamHpB8Z99uE=; b=kU8LKJQ+EwUcTTJTaFhwCAhbgC0h5q+cDOgttH6T3hTKK6q+IqeICOlkwoRQNOg1Mf eAbkFlZlVo0DVNOu7uBagKofvYOMX86wpfnMu9TZrpdsJ6lQNAdlmRcMKWT88o3w1uHG USPiAmk+sUGe7HurRwief2OEQWEXr5oEB7+yib/A49AAQ46PVPDDuyMybZOY8zs7eBFt OMST/F099OflnsdBvxS+BYZRrBBq+gmtqJuNeedkOD3a8dlsLxpZm5L6Dv4/G5r7wUaO 2Zfqf0/UPfsHrllPnS73275qMnmpjRG5fqbTXlPg/EUfoXi6fyE9zwpuGMxgkIFof479 eOBQ== X-Gm-Message-State: AAQBX9cylG9s7KNTTX+rfD4FVmedw42ODe730YT0XnSRDyGt1vd7TFMg oFqy6Avgh8ULz3svMOokLxOt17RRNts= X-Google-Smtp-Source: AKy350bnW6G4sc3TzluZqiCzdlZZMYFypOkTqsa3utmUOfEc/LNEyJmJTU31Clu7F6rfYAHwqIqb0w== X-Received: by 2002:a05:6a21:100e:b0:f1:8f7:eeb5 with SMTP id nk14-20020a056a21100e00b000f108f7eeb5mr15829446pzb.60.1682366195917; Mon, 24 Apr 2023 12:56:35 -0700 (PDT) Received: from smtpclient.apple (180-150-38-128.b49626.bne.nbn.aussiebb.net. [180.150.38.128]) by smtp.gmail.com with ESMTPSA id w75-20020a62824e000000b0063b17b58822sm7795367pfd.74.2023.04.24.12.56.34 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 24 Apr 2023 12:56:35 -0700 (PDT) Content-Type: multipart/alternative; boundary=Apple-Mail-5FB4B327-B1CD-483F-B3DF-0D4E37B76708 Content-Transfer-Encoding: 7bit From: David Wheeler Mime-Version: 1.0 (1.0) Subject: Re: what happens if a failed transaction is not rolled back? Date: Tue, 25 Apr 2023 05:56:22 +1000 Message-Id: <5AE892DD-A808-4874-AAD4-C47E5C92E28D@gmail.com> References: Cc: Siddharth Jain , pgsql-general@lists.postgresql.org In-Reply-To: To: "David G. Johnston" X-Mailer: iPhone Mail (20B101) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-5FB4B327-B1CD-483F-B3DF-0D4E37B76708 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable > On 25 Apr 2023, at 1:47 am, David G. Johnston = wrote: >=20 > There isn't anything special about a failed transaction compared to any ot= her transaction that you leave open. Now I=E2=80=99m curious. Does it have the same impact on performance that an= idle in transaction connection has? Eg does it prevent vacuum? Does it stil= l hold locks? David= --Apple-Mail-5FB4B327-B1CD-483F-B3DF-0D4E37B76708 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

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

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

Now I=E2=80=99m curious. Does it have the same impact on per= formance that an idle in transaction connection has? Eg does it prevent vacu= um? Does it still hold locks?

David
= --Apple-Mail-5FB4B327-B1CD-483F-B3DF-0D4E37B76708--