pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Willem Leenen <willem_leenen@hotmail.com>
To: mike.blackwell@rrd.com
To: klaussfreire@gmail.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Savepoints in transactions for speed?
Date: Wed, 28 Nov 2012 15:23:21 +0000
Message-ID: <DUB104-W3775F9EFC7F49ED475B188F5D0@phx.gbl> (raw)
In-Reply-To: <CANPAkgt2A2YnnGV_kmq9wVpZHaSLg2KrZdK+6e6K8Vu3j2Lc+g@mail.gmail.com>
References: <CANPAkgs_LvZV-fabTNN-ahiVcwSBAyOnArw1v+QbCePg7on6ZA@mail.gmail.com>
	<2000E26E-35FC-4801-90F3-3CFBDA7B41DF@yahoo.com>
	<CANPAkgsod2N+=oviHmhC0uXPAZixe4PPbMt_cx0iRLanyQdnHg@mail.gmail.com>
	<CAGTBQpZ-NLHeZPnD9m2O-UZfMba14t1aU2K73c0tOvz_w232LQ@mail.gmail.com>
	<CANPAkgt2A2YnnGV_kmq9wVpZHaSLg2KrZdK+6e6K8Vu3j2Lc+g@mail.gmail.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>



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: [PERFORM] Savepoints in transactions for speed?
From: mike.blackwell@rrd.com
To: klaussfreire@gmail.com
CC: pgsql-performance@postgresql.org



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  		 	   		  =

view thread (22+ messages)  latest in thread

Message-ID: <DUB104-W3775F9EFC7F49ED475B188F5D0@phx.gbl>
Permalink:  ../DUB104-W3775F9EFC7F49ED475B188F5D0@phx.gbl/
Also on:    postgresql.org/message-id/DUB104-W3775F9EFC7F49ED475B188F5D0@phx.gbl

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: willem_leenen@hotmail.com, mike.blackwell@rrd.com, klaussfreire@gmail.com
  Subject: Re: Savepoints in transactions for speed?
  In-Reply-To: <DUB104-W3775F9EFC7F49ED475B188F5D0@phx.gbl>
  References: <CANPAkgs_LvZV-fabTNN-ahiVcwSBAyOnArw1v+QbCePg7on6ZA@mail.gmail.com> <2000E26E-35FC-4801-90F3-3CFBDA7B41DF@yahoo.com> <CANPAkgsod2N+=oviHmhC0uXPAZixe4PPbMt_cx0iRLanyQdnHg@mail.gmail.com> <CAGTBQpZ-NLHeZPnD9m2O-UZfMba14t1aU2K73c0tOvz_w232LQ@mail.gmail.com> <CANPAkgt2A2YnnGV_kmq9wVpZHaSLg2KrZdK+6e6K8Vu3j2Lc+g@mail.gmail.com> <DUB104-W3775F9EFC7F49ED475B188F5D0@phx.gbl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox