Row Level Locking !!
Row Level Locking !!
От:
"Mahesh Guleria" <mahesh@himline.com>
Дата:
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. -MG
Re: Row Level Locking !!
От:
Christof Glaser <gcg@gl.aser.de>
Дата:
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
Re: [SQL] Re: Row Level Locking !!
От:
Roberto Mello <rmello@cc.usu.edu>
Дата:
On Wed, Jun 20, 2001 at 01:03:49PM +0200, Christof Glaser wrote:
> 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.
I'd like to point out (for the new users around) that PostgreSQL
has had Multi Version Concurrency Control for quite some time. You don't
have to do anything special to use it. It's the default to handle
concurrency.
-Roberto
--
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http://www.sdl.usu.edu - Space Dynamics Lab, Developer
* * * <- Tribbles . . . <- Tribbles after a haircut