Question on concurrency controls
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
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
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
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