O'Reilly Open Source Software Convention 2002

	Home
	Registration
	Speakers
	Keynotes
	Tutorials
	Sessions
	At-a-Glance
	BOFs
	Events
	Exhibitors
	Sponsors
	Hotel/Travel
	Venue Map
	See & Do
	Press
	Mail List

From the Frontiers of Research to the Heart of the Enterprise
O'Reilly Open Source Convention
Sheraton San Diego Hotel and Marina
July 22-26, 2002 -- San Diego, CA

Apache
Session
PostgreSQL Concurrency Issues
Tom Lane, Red Hat, Inc.

Track: Databases
Date: Friday, July 26
Time: 2:30pm - 3:15pm
Location: Sea Breeze I
This talk describes how relational databases handle, and particularly PostgreSQL, work in a multi-user environment. It covers the locking and visibility issues that are inherent in multi-user sites, and how PostgreSQL handles such situations.
We’ll cover transactions, multi-statement queries, row visibility, row isolation levels, locking, deadlocks, and unique row numbering challenges. It will also explain typical problems that happen in a multi-user environment, and how PostgreSQL handles them, and how predicable results can be obtained with maximum concurrency.

Download presentation file