Re: SSI non-serializable UPDATE performance - Mailing list pgsql-hackers

From Dan Ports
Subject Re: SSI non-serializable UPDATE performance
Date
Msg-id 20110427175914.GB1432@csail.mit.edu
Whole thread Raw
In response to Re: SSI non-serializable UPDATE performance  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
On Wed, Apr 27, 2011 at 06:26:52PM +0100, Simon Riggs wrote:
> Reading the code, IIUC, we check for RW conflicts after each write but
> only if the writer is running a serializable transaction.
> 
> Am I correct in thinking that there is zero impact of SSI if nobody is
> running a serializable transaction?

That is correct, now.

(Well, other than having to check whether a serializable transaction is
running, the cost of which is truly negligible.)

Dan

-- 
Dan R. K. Ports              MIT CSAIL                http://drkp.net/


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: "stored procedures" - use cases?
Next
From: "Kevin Grittner"
Date:
Subject: Re: SSI non-serializable UPDATE performance