| 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: | Whole Thread | Raw Message | 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
| 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 |