Hello:

I'd like to learn a bit about how concurrency control is managed by
PostgreSQL, for a project I'm starting.  I looked over the documentation,
FAQs, features lists, etc. on the postgresql web site but they are aimed
more toward users and application programmers than tech-heads who want to
look under the hood.

I'm just wondering (a) what scheme(s) PostgreSQL uses (eg. two-phase
locking, timestamp, etc.), (b) what recovery procedures are available, and
(c) what source code modules I should concentrate looking at to see how
these controls have been implemented.

Thanks in advance.

--------------< LINUX: The choice of a GNU generation. >--------------
Steve Frampton  <3srf@qlink.queensu.ca>  http://qlink.queensu.ca/~3srf


Thu, 29 Oct 1998 20:04:19 -0500 (EST)
Steve Frampton <frampton@mail.flarc.edu.on.ca>
Question on concurrency controls
Hello:

Is it true that there is no support for row-level locking at this time?
Is this something that is being worked on?

Thanks...

--------------< LINUX: The choice of a GNU generation. >--------------
Steve Frampton  <3srf@qlink.queensu.ca>  http://qlink.queensu.ca/~3srf


Sun, 1 Nov 1998 17:01:27 -0500 (EST)
Steve Frampton <frampton@mail.flarc.edu.on.ca>
Re: Question on concurrency controls
On Sun, 1 Nov 1998, Steve Frampton wrote:

> Hello:
> 
> Is it true that there is no support for row-level locking at this time?
> Is this something that is being worked on?

	Yes, and yes...

	Vadim has it planned for v6.5...v6.4 is just about to be released,
with v6.5 being released first third new year :)

Marc G. Fournier                                
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 


Sun, 1 Nov 1998 18:28:02 -0400 (AST)
The Hermit Hacker <scrappy@hub.org>
Re: [HACKERS] Re: Question on concurrency controls
> 
> On Sun, 1 Nov 1998, Steve Frampton wrote:
> 
> > Is it true that there is no support for row-level locking at this time?
> > Is this something that is being worked on?
> 
> 	Yes, and yes...
> 
> 	Vadim has it planned for v6.5...v6.4 is just about to be released,
> with v6.5 being released first third new year :)
> 

Interesting... please let me know what levels of concurrency are available ?
Alternatively is there documentation describing concurrency?

Regards
Theo



Tue, 3 Nov 1998 07:22:52 +0200 (SAST)
Theo Kramer <theo@flame.flame.co.za>
Re: [HACKERS] Re: Question on concurrency controls