Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR : invalid transaction termination : PostgreSQL v12 - Mailing list pgsql-admin

From David G. Johnston
Subject Re: ERROR : invalid transaction termination : PostgreSQL v12
Date
Msg-id CAKFQuwZDfW2THiNe0Y95YLKGugH8h_7T1KOfCr7E7w3B1BPJZA@mail.gmail.com
Whole thread Raw
In response to Re: ERROR : invalid transaction termination : PostgreSQL v12  (Holger Jakobs <holger@jakobs.com>)
Responses Re: ERROR : invalid transaction termination : PostgreSQL v12  (Holger Jakobs <holger@jakobs.com>)
List pgsql-admin
Tree view
On Tue, Nov 24, 2020 at 12:57 AM Holger Jakobs <holger@jakobs.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.

pgsql-admin by date:

Previous
From: Keith
Date:
Subject: Re: Re-index
Next
From: Laurenz Albe
Date:
Subject: Re: Streaming Replication replay lag