Re: Major features for 9.1 - Mailing list pgsql-advocacy

From Florian Weimer
Subject Re: Major features for 9.1
Date
Msg-id 82wrjb73zi.fsf@mid.bfk.de
Whole thread Raw
In response to Re: Major features for 9.1  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List 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@bfk.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

pgsql-advocacy by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Major features for 9.1
Next
From: Emanuel Calvo
Date:
Subject: Re: Major features for 9.1