Thread: 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