Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id ED2A41337B4C
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun, 10 Oct 2010 12:29:57 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 87180-01
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun, 10 Oct 2010 15:29:49 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from hrndva-omtalb.mail.rr.com (hrndva-omtalb.mail.rr.com
	[71.74.56.124])
	by mail.postgresql.org (Postfix) with ESMTP id 782821337B48
	for <pgsql-performance@postgresql.org>;
	Sun, 10 Oct 2010 12:29:49 -0300 (ADT)
X-Authority-Analysis: v=1.1 cv=QISHQ+x4xS+apxgDHgAvNvlUjyrXCzYsHvuXcbPYiKg=
	c=1 sm=0 a=uLnYnW5vPakA:10 a=RAii6je2cdnAH6ATCOpc6g==:17
	a=_Ixf_7qHAAAA:8 a=7nLAeaaVB8gglJ33k3IA:9
	a=12KxhISqLDxH2Zad5tbPQMq2O4gA:4 a=wPNLvfGTeEIA:10
	a=ryAo9hy1-OkA:10 a=6vsjEBoLwlAA:10 a=0tfO7MgyNwYA:10
	a=fVcfVH1IUqFWlEFJtDkA:9 a=lXyZllZXlEMkq4YYf9QA:7
	a=KrXDAyY3Y9qMfxlBj9yugvnCOEcA:4 a=RAii6je2cdnAH6ATCOpc6g==:117
X-Cloudmark-Score: 0
X-Originating-IP: 74.73.87.196
Received: from [74.73.87.196] ([74.73.87.196:50460] helo=[192.168.1.103])
	by hrndva-oedge04.mail.rr.com (envelope-from
	<mladen.gogala@vmsinfo.com>) (ecelerity 2.2.3.46 r()) with ESMTP
	id F2/46-11377-CEBD1BC4; Sun, 10 Oct 2010 15:29:48 +0000
Message-ID: <4CB1DBED.70607@vmsinfo.com>
Date: Sun, 10 Oct 2010 11:29:49 -0400
From: Mladen Gogala <mladen.gogala@vmsinfo.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US;
	rv:1.9.2.9) Gecko/20100915 Lightning/1.0b2 Thunderbird/3.1.4
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: large dataset with write vs read clients
References: <AANLkTimNJc=0ffgRO_gO6Vsq06=aqBYXZouhbv0kBe-i@mail.gmail.com>
	<4CAE3FDB.1040909@2ndquadrant.com>
	<87ocb3yu10.fsf@mid.deneb.enyo.de>	<4CB0E006.8010905@vmsinfo.com>
	<871v7y2rwi.fsf@mid.deneb.enyo.de>
In-Reply-To: <871v7y2rwi.fsf@mid.deneb.enyo.de>
Content-Type: multipart/alternative;
	boundary="------------080601070905070403020708"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201010/95
X-Sequence-Number: 40514

This is a multi-part message in MIME format.
--------------080601070905070403020708
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

  On 10/10/2010 7:45 AM, Florian Weimer wrote:
> Some people use RDBMSs mostly for the*M*  part, to get a consistent
> administration experience across multiple applications.  And even with
> asynchronous commits, PostgreSQL will maintain a consistent state of
> the database.

Both Postgres and Oracle have that option and both databases will 
maintain the consistent state, but both databases will allow the loss of 
data in case of system crash.  Strictly speaking, that does break the 
"D" in  ACID.

-- 
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com


--------------080601070905070403020708
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#ffffff" text="#000000">
    On 10/10/2010 7:45 AM, Florian Weimer wrote:
    <blockquote cite="mid:871v7y2rwi.fsf@mid.deneb.enyo.de" type="cite">
      <pre wrap="">Some people use RDBMSs mostly for the <b class="moz-txt-star"><span class="moz-txt-tag">*</span>M<span class="moz-txt-tag">*</span></b> part, to get a consistent
administration experience across multiple applications.  And even with
asynchronous commits, PostgreSQL will maintain a consistent state of
the database.
</pre>
    </blockquote>
    <br>
    Both Postgres and Oracle have that option and both databases will
    maintain the consistent state, but both databases will allow the
    loss of data in case of system crash.&nbsp; Strictly speaking, that does
    break the "D" in&nbsp; ACID.<br>
    <br>
    <pre class="moz-signature" cols="72">-- 
Mladen Gogala 
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
<a class="moz-txt-link-abbreviated" href="http://www.vmsinfo.com">www.vmsinfo.com</a> 
</pre>
  </body>
</html>

--------------080601070905070403020708--