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