Concurrency control using postgres

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.
http://www.commandprompt.com/community/pgdocs81/index
This is an awesome postgres resource