PostgreSQL and ACID properties support

From: nzanella(at)cs(dot)mun(dot)ca (Neil Zanella)
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL and ACID properties support
Date: 2003-08-08 04:28:52
Message-ID: b68d2f19.0308072028.56413991@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I would like to know to what extent PostgreSQL includes support for the ACID
properties of transactions (Atomicity, Consistency, Isolation, and Durability).
In particular, does PostgreSQL include constructs to guarantee that a sequence
of SQL statements is executed atomically (i.e., either all execute to completion
or none of them do). Also, with regards to isolation, what is the status of
PostgreSQL's implementation with respect to providing the option of concurrency
of transactions as opposed to the operations taking place serially? Also, does
PostgreSQL fully support SQL99 CHECK constraints? And if the system crashes...
is the database guaranteed to remain in a consistent state?

Thanks,

Neil

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2003-08-08 05:03:58 Re: postmaster(s) have high load average
Previous Message Chris Hutchinson 2003-08-08 03:04:34 Re: Auditing idea