Re: large dataset with write vs read clients - Mailing list pgsql-performance

From Mladen Gogala
Subject Re: large dataset with write vs read clients
Date
Msg-id 4CB1DBED.70607@vmsinfo.com
Whole thread Raw
In response to Re: large dataset with write vs read clients  (Florian Weimer <fw@deneb.enyo.de>)
List pgsql-performance
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 

pgsql-performance by date:

Previous
From: Віталій Тимчишин
Date:
Subject: Re: Slow count(*) again...
Next
From: Craig Ringer
Date:
Subject: Re: Slow count(*) again...