Re: large dataset with write vs read clients

From: Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: large dataset with write vs read clients
Date: 2010-10-10 15:29:49
Message-ID: 4CB1DBED.70607@vmsinfo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Craig Ringer 2010-10-10 15:30:09 Re: Slow count(*) again...
Previous Message Reid Thompson 2010-10-10 15:02:32 Re: Slow count(*) again...