Postgres Pro
Downloads
Home   >   mailing lists

Re: Row Level Locking !! - Mailing list pgsql-admin

From Christof Glaser
Subject Re: Row Level Locking !!
Date
Msg-id 01062013035000.00721@pinguin
Whole thread Raw
In response to Row Level Locking !!  ("Mahesh Guleria" <mahesh@himline.com>)
Responses Re: [SQL] Re: Row Level Locking !!  (Roberto Mello <rmello@cc.usu.edu>)
List pgsql-admin
Tree view 
On Wednesday, 20. June 2001 07:46, Mahesh Guleria wrote:

> Is it possible that we can use row level locking in postgres.
> If "yes",
> then but is the proceedure and where i can found the documentation.

There is "something better than row level locking" called MVCC, or
Multi Version Concurrency Control for short.

See Chapter 9 of the User Guide:

http://www.postgresql.org/idocs/index.php?mvcc.html

Hope that helps,
Christof
--
          gl.aser . software engineering . internet service
       http://gl.aser.de/  . Planckstraße 7 . D-39104 Magdeburg

pgsql-admin by date:

Previous
From: "Rainer Mager"
Date:
Subject: RE: High memory usage
Next
From: "pgsql-admin"
Date:
Subject: Re(2): 7.0.3 -> 7.1.2; pg_setlocale error