Re: PG_DUMP and table locking in PG7.4

From: Yann Michel <yann-postgresql(at)spline(dot)de>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PG_DUMP and table locking in PG7.4
Date: 2005-11-16 20:39:41
Message-ID: 20051116203941.GA22667@zoom.spline.inf.fu-berlin.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Martijn,

On Wed, Nov 16, 2005 at 09:47:33AM +0100, Martijn van Oosterhout wrote:
>
> Ah yes, PostgreSQL doesn't use 2PL, it uses MVCC. quick overview here:
> http://linuxgazette.net/issue68/mitchell.html

THX! That was interesting!

> > Thanks. BTW: Is there anything about locks and their meaning inside of
> > the Docs? If not, wouldn't that be nice?
>
> Check here:
> http://www.postgresql.org/docs/8.0/interactive/mvcc.html
>
> Under "Explicit Locking" it lists all the locks and what they're for.

Yes, thanks once more!

Cheers,
Yann

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Yann Michel 2005-11-16 20:43:25 Re: PG_DUMP and table locking in PG7.4
Previous Message Tom Lane 2005-11-16 20:32:59 Re: Some array semantics issues