Skip site navigation (1) Skip section navigation (2)

Re: ACID (was Re: Reliable and fast ...)

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ACID (was Re: Reliable and fast ...)
Date: 2007-08-29 16:20:32
Message-ID: 46D59CD0.8010404@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Ron Johnson wrote:
> On 08/29/07 10:40, Joshua D. Drake wrote:
>> Ron Johnson wrote:

>>> Argh!!!  The RDBMS that I typically use defaults to SERIALIZABLE.
>> SERIALIZABLE is really slow :). You should look into SERIALIZABLE only
>> for those transactions that need it. There is also SELECT FOR UPDATE.
> 
> We use SERIALIZABLE (with all it's locking "issues") to guarantee
> the I in ACID.  ISTM that READ COMMITTED can only deliver "ACD".

You are using serializable for select statements?


- ---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster



- --

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/
			UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFG1ZzQATb/zqfZUUQRAm+lAJ4i8s6I2MKCQGo1zD3g2w5lPRFikwCeNZML
4bV06CiM196qwC2l5MKqn10=
=ygzn
-----END PGP SIGNATURE-----

In response to

Responses

pgsql-general by date

Next:From: Ron JohnsonDate: 2007-08-29 16:22:14
Subject: Re: ACID (was Re: Reliable and fast ...)
Previous:From: David FetterDate: 2007-08-29 16:15:37
Subject: Re: Is there a better way to do this?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group