Skip site navigation (1) Skip section navigation (2)

Re: Major features for 9.1

From: Florian Weimer <fweimer(at)bfk(dot)de>
To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: "Josh Berkus" <josh(at)agliodbs(dot)com>, "PostgreSQL Advocacy" <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: Major features for 9.1
Date: 2011-04-03 15:24:01
Message-ID: 82wrjb73zi.fsf@mid.bfk.de (view raw or flat)
Thread:
Lists: pgsql-advocacy
* Kevin Grittner:

>> * SSI: Serializable Snapshot Isolation
>> True serializability without locking.  Eliminate a lot of SELECT
>> FOR UPDATE code.
>> This might also be a PostgreSQL first.
>  
> Obviously *I* think it's big.  Besides the on-list posts, I've
> gotten quite a few off-list emails and comments at conferences which
> make me think there are a lot of others interested.  Notice the
> aggressive testing it got once it hit alpha.  I'm pretty sure I'd
> have heard about it or run across it in web searches if anybody else
> had beat us to this.  (I would say that "without blocking" would be
> more technically accurate than "without locking".)
>  
> +1

Does SSI address the UPSERT race?  If yes, it's going to help a lot of
people indeed.

-- 
Florian Weimer                <fweimer(at)bfk(dot)de>
BFK edv-consulting GmbH       http://www.bfk.de/
Kriegsstraße 100              tel: +49-721-96201-1
D-76133 Karlsruhe             fax: +49-721-96201-99

In response to

pgsql-advocacy by date

Next:From: Emanuel CalvoDate: 2011-04-03 15:40:16
Subject: Re: Major features for 9.1
Previous:From: Peter EisentrautDate: 2011-04-03 09:43:12
Subject: Re: Major features for 9.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group