Lock questions - Mailing list pgsql-general

From Fernando
Subject Lock questions
Date
Msg-id 20031118170149.ACFA63C03C@smtp.latinmail.com
Whole thread Raw
Responses Re: Lock questions  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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
aboutlocks: 
  - 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
saysthat "USER locks are non-blocking", how could this be? 

Thank you very much!


____________________________________________________________
http://webmail.wanadoo.es. Tu correo gratuito, r�pido y en espa�ol


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: E-Week Magazine looking for users
Next
From: "Keith C. Perry"
Date:
Subject: Re: building 7.4 with plperl