Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 7FB59B5DC16 for ; Tue, 13 Sep 2011 17:59:49 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 10870-08 for ; Tue, 13 Sep 2011 20:59:43 +0000 (UTC) X-Greylist: delayed 01:11:05.684708 by SQLgrey-1.7.6 Received: from queueout04-winn.ispmail.ntl.com (queueout04-winn.ispmail.ntl.com [81.103.221.58]) by mail.postgresql.org (Postfix) with ESMTP id 20D5EB5DBD8 for ; Tue, 13 Sep 2011 17:59:28 -0300 (ADT) Received: from know-smtpout-4.server.virginmedia.net ([62.254.123.2]) by mtaout01-winn.ispmail.ntl.com (InterMail vM.7.08.04.00 201-2186-134-20080326) with ESMTP id <20110913194820.OWYF9871.mtaout01-winn.ispmail.ntl.com@know-smtpout-4.server.virginmedia.net> for ; Tue, 13 Sep 2011 20:48:20 +0100 Received: from [77.99.161.245] (helo=albo.gi.lan) by know-smtpout-4.server.virginmedia.net with esmtp (Exim 4.63) (envelope-from ) id 1R3Yxw-00020i-H2 for pgsql-performance@postgresql.org; Tue, 13 Sep 2011 20:48:20 +0100 Received: from gianni by albo.gi.lan with local (masqmail 0.2.27) id 1R3Yxv-1yf-00 for ; Tue, 13 Sep 2011 20:48:19 +0100 Date: Tue, 13 Sep 2011 20:48:19 +0100 From: Gianni Ciolli To: pgsql-performance@postgresql.org Subject: Re: Postgres for a "data warehouse", 5-10 TB Message-ID: <20110913194819.GA5715@albo.gi.lan> References: <4E6CC458.4010206@squeakycode.net> <4E6E3FE8.5070609@squeakycode.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.21 (2010-09-15) X-Cloudmark-Analysis: v=1.1 cv=R50lirqlHffDPPkwUlkuVa99MrvKdVWo//yz83qex8g= c=1 sm=0 a=wom5GMh1gUkA:10 a=5jZfxJ1uyz8A:10 a=b30I1FEBwLAA:10 a=kj9zAlcOel0A:10 a=epTmVMiNAAAA:8 a=Rdvl4hr_AAAA:8 a=9TqEVyMoV8nUBO3tu7UA:9 a=CjuIK1q_8ugA:10 a=i7TXcKCSneIA:10 a=mDa6mRmOxOMA:10 a=HpAAvcLHHh0Zw7uRqdWCyQ==:117 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201109/195 X-Sequence-Number: 44971 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