Re: Postgres for a "data warehouse", 5-10 TB - Mailing list pgsql-performance

From Gianni Ciolli
Subject Re: Postgres for a "data warehouse", 5-10 TB
Date
Msg-id 20110913194819.GA5715@albo.gi.lan
Whole thread Raw
In response to Re: Postgres for a "data warehouse", 5-10 TB  (Robert Klemme <shortcutter@googlemail.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Postgres for a "data warehouse", 5-10 TB
Next
From: "Kevin Grittner"
Date:
Subject: Re: Migrated from 8.3 to 9.0 - need to update config (re-post)