Re: ERROR : invalid transaction termination : PostgreSQL v12

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Holger Jakobs <holger(at)jakobs(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: ERROR : invalid transaction termination : PostgreSQL v12
Date: 2020-11-24 15:39:31
Message-ID: CAKFQuwZDfW2THiNe0Y95YLKGugH8h_7T1KOfCr7E7w3B1BPJZA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Nov 24, 2020 at 12:57 AM Holger Jakobs <holger(at)jakobs(dot)com> wrote:

> What is the point of COMMITting after a few records? Why not let the whole
> batch run through. If there are any errors, PostgreSQL will rollback the
> whole transaction anyway.
>
Avoiding that behavior is the point of batching with periodic commits.

David J.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2020-11-24 16:05:29 Re: Streaming Replication replay lag
Previous Message Keith 2020-11-24 15:09:49 Re: Re-index