Re: MVCC cons

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: MVCC cons
Date: 2007-08-15 01:59:34
Message-ID: 46C25E06.9000709@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 08/14/07 20:36, Merlin Moncure wrote:
[snip]
>
> PostgreSQL wins in terms of better concurrency (especially in long
> transactions or transactions that touch a lot of records), cheap
> rollbacks, and all the advantages of a sophisticated locking engine
> (transactional ddl for example).

Although MVCC is not a /sine qua non/ of transactional ddl.

- --
Ron Johnson, Jr.
Jefferson LA USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGwl4GS9HxQb37XmcRAhm5AJ9pSZR08Vj5aOYtMnQdQaPsjtPMOQCghP+v
k81CxBZyH/42wHjPeT0Azvc=
=WRv0
-----END PGP SIGNATURE-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-08-15 02:06:01 Re: Trigger not working as expected, first row gets a null value
Previous Message Tom Lane 2007-08-15 01:57:32 Re: more select-for-update questions