Re: Savepoints in transactions for speed?

[Willem Leenen <willem_leenen@xxxxxxxxxxx>]

Commitmarks are written to disk after each transaction. So transactionsize has impact on performance.

---

Date: Wed, 28 Nov 2012 09:18:20 -0600
Subject: Re: Savepoints in transactions for speed?
From: mike.blackwell@xxxxxxx
To: klaussfreire@xxxxxxxxx
CC: pgsql-performance@xxxxxxxxxxxxxx

On Tue, Nov 27, 2012 at 7:16 PM, Claudio Freire <klaussfreire@xxxxxxxxx> wrote:

Updates, are faster if batched, if your business logic allows it,

because it creates less bloat and creates more opportunities for with
HOT updates. I don't think it applies to inserts, though, and I
haven't heard it either.

Ah.  That must have been what I'd half-remembered.  Thanks for the clarification.

Mike