Re: 12 Silver Bullets

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Greg Smith <gsmith(at)gregsmith(dot)com>, Bob Zurek <bob(dot)zurek(at)enterprisedb(dot)com>, pgsql-advocacy(at)postgresql(dot)org
Subject: Re: 12 Silver Bullets
Date: 2007-08-16 16:43:36
Message-ID: 1187282616.24679.5.camel@dogma.ljc.laika.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy

On Thu, 2007-08-16 at 06:15 +0100, Simon Riggs wrote:
> On Thu, 2007-08-16 at 00:22 -0400, Greg Smith wrote:
>
> > 2. Robust transactional ACID behavior under all circumstances
>
> Async commit changes that, since it relaxes the Durability aspect.
>

fsync, too.

I think there are some important differences between PostgreSQL having a
few options which can trade away data safety, and what MySQL does.

1. PostgreSQL is about as safe as you can get with default options.
2. In PostgreSQL, all features are available and all semantic behaviors
are consistent in the safest mode of operation.

Neither of these things are true with MySQL.

Regards,
Jeff Davis

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message David Fetter 2007-08-16 16:49:31 Re: 12 Silver Bullets
Previous Message Decibel! 2007-08-16 15:51:47 Re: 12 Silver Bullets