Re: Savepoints in transactions for speed? - Mailing list pgsql-performance

From Mike Blackwell
Subject Re: Savepoints in transactions for speed?
Date
Msg-id CANPAkgt2A2YnnGV_kmq9wVpZHaSLg2KrZdK+6e6K8Vu3j2Lc+g@mail.gmail.com
Whole thread Raw
In response to Re: Savepoints in transactions for speed?  (Claudio Freire <klaussfreire@gmail.com>)
Responses Re: Savepoints in transactions for speed?
List pgsql-performance


On Tue, Nov 27, 2012 at 7:16 PM, Claudio Freire <klaussfreire@gmail.com> 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 

pgsql-performance by date:

Previous
From: Willem Leenen
Date:
Subject: Re: Optimize update query
Next
From: Willem Leenen
Date:
Subject: Re: Savepoints in transactions for speed?