Lock questions

From: Fernando <proyectolsd(at)wanadoo(dot)es>
To: pgsql-general(at)postgresql(dot)org
Subject: Lock questions
Date: 2003-11-18 17:01:52
Message-ID: 20031118170149.ACFA63C03C@smtp.latinmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
i've been reading the README file in the lmgr folder (in src/backend/storage/lmgr/) and i have a couple of questions about locks:
- What's the difference between the Lightweight Locks (LWLocks) and the Regular locks (Heavyweight Locks)? For example, if i do a query and it needs a lock, would it be a lightweight one or a regular one?

- There are two lock methods, DEFAULT and USER. Where can I get more information about them? In the README file it says that "USER locks are non-blocking", how could this be?

Thank you very much!

____________________________________________________________
http://webmail.wanadoo.es. Tu correo gratuito, rpido y en espaol

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Keith C. Perry 2003-11-18 17:09:22 Re: building 7.4 with plperl
Previous Message Bruce Momjian 2003-11-18 16:49:33 E-Week Magazine looking for users