Re: Savepoints in transactions for speed?

From: Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com>
To: Claudio Freire <klaussfreire(at)gmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Savepoints in transactions for speed?
Date: 2012-11-28 15:18:20
Message-ID: CANPAkgt2A2YnnGV_kmq9wVpZHaSLg2KrZdK+6e6K8Vu3j2Lc+g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Nov 27, 2012 at 7:16 PM, Claudio Freire <klaussfreire(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Willem Leenen 2012-11-28 15:23:21 Re: Savepoints in transactions for speed?
Previous Message Willem Leenen 2012-11-28 15:11:46 Re: Optimize update query