pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Gianni Ciolli <gianni.ciolli@2ndquadrant.it>
To: pgsql-performance@postgresql.org
Subject: Re: Postgres for a "data warehouse", 5-10 TB
Date: Tue, 13 Sep 2011 20:48:19 +0100
Message-ID: <20110913194819.GA5715@albo.gi.lan> (raw)
In-Reply-To: <j4ltdo$r65$1@dough.gmane.org>
References: <CAMhtkAbK7saRO_Tayb1nS3YLWN=Wns=Ci47qs-3YbX0T2+hkpA@mail.gmail.com>
	<CAOR=d=0zmw-EGRJyYmwCTxR5g6osbFLS5i-3kzjG05j7S=1JaA@mail.gmail.com>
	<CAMhtkAah2c4XfSec=OtgL1V51wpD=jygbZnBVBRYCV02MscebQ@mail.gmail.com>
	<4E6CC458.4010206@squeakycode.net>
	<CABRT9RB-etP-K-0u0y-Wv+BysSd9ToZm71BqcY7hFQZC2tmjYQ@mail.gmail.com>
	<j4lens$hp0$1@dough.gmane.org>
	<4E6E3FE8.5070609@squeakycode.net>
	<j4ltdo$r65$1@dough.gmane.org>

On Mon, Sep 12, 2011 at 11:26:10PM +0200, Robert Klemme wrote:
> You make them sound like witchcraft.  But they are clearly defined -
> even standardized.  Granted, different RDBMS might implement them in
> different ways - here's PG's view of TX isolation:
> 
> http://www.postgresql.org/docs/8.4/interactive/transaction-iso.html

Even better: PostgreSQL 9.1 (Released yesterday! Fresher than milk...)
ships an improved algorithm for serializable transaction isolation
level:

  http://www.postgresql.org/docs/9.1/interactive/transaction-iso.html

More info:

  http://wiki.postgresql.org/wiki/Serializable

Cheers,
Dr. Gianni Ciolli - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gianni.ciolli@2ndquadrant.it | www.2ndquadrant.it

view thread (48+ messages)  latest in thread

Message-ID: <20110913194819.GA5715@albo.gi.lan>
Permalink:  ../20110913194819.GA5715@albo.gi.lan/
Also on:    postgresql.org/message-id/20110913194819.GA5715@albo.gi.lan

copy link · copy postgr.es

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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: gianni.ciolli@2ndquadrant.it
  Subject: Re: Postgres for a "data warehouse", 5-10 TB
  In-Reply-To: <20110913194819.GA5715@albo.gi.lan>

* 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