Improving foreign key concurrency
Formal Metadata
Title 
Improving foreign key concurrency

Title of Series  
Number of Parts 
21

Author 

Contributors 

License 
CC Attribution  NonCommercial  ShareAlike 3.0 Unported:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal and noncommercial purpose as long as the work is attributed to the author in the manner specified by the author or licensor and the work or content is shared also in adapted form only under the conditions of this license. 
Identifiers 

Publisher 

Release Date 
2012

Language 
English

Producer 

Content Metadata
Subject Area  
Abstract 
To lock and not to block Row locking is a mechanism that lets Postgres maintain strict consistency in certain database constraints, such as foreign keys. However, Postgres has historically only provided share and exclusive row locking, which I'll show to have significant drawbacks for concurrency. To solve the concurrency problem, two new row lock types are being introduced in release 9.2: SELECT FOR KEY SHARE and SELECT FOR KEY UPDATE. In this talk I'll explain how this new locking came to be, how it works, and how it helps significantly improve concurrency in applications.

00:00
Metropolitan area network
Computer icon
Standard deviation
Mathematical singularity
1 (number)
Maxima and minima
Ext functor
Density of states
Port scanner
Valueadded network
Regular graph
Computer animation
Revision control
Set (mathematics)
IRIST
Energy level
Key (cryptography)
Videoconferencing
Conditionalaccess module
Extension (kinesiology)
08:02
Asynchronous Transfer Mode
Freeware
Table (information)
Mountain pass
Logarithm
Maxima and minima
Mach's principle
Regular graph
Set (mathematics)
Musical ensemble
Arithmetic logic unit
Multiplication
Chisquared distribution
Metropolitan area network
Serial port
Information systems
State of matter
Density of states
Port scanner
Euler angles
Deadlock
Johann Peter Hebel
Computer animation
Normal (geometry)
Key (cryptography)
Integer
Extension (kinesiology)
15:44
Computer icon
Metropolitan area network
Asynchronous Transfer Mode
Patch (Unix)
1 (number)
Maxima and minima
Mass
Computer animation
Military operation
Normal (geometry)
Key (cryptography)
Normal (geometry)
Modem
21:22
Metropolitan area network
Optical character recognition
Executive information system
Information systems
Bit rate
Electronic mailing list
Arm
Valueadded network
Computer animation
Revision control
Key (cryptography)
Normal (geometry)
Tunis
25:39
Metropolitan area network
Robot
Asynchronous Transfer Mode
Computer file
1 (number)
Einstein field equations
Binary file
Bit
Singleprecision floatingpoint format
Order (biology)
Flow separation
Computer animation
Revision control
Key (cryptography)
Implementation
32:38
Mathematics
Plane (geometry)
Computer animation
Gradient
Revision control
1 (number)
Maxima and minima
Code
Normal (geometry)
Block (periodic table)
00:05
the form of of of of of of of of many
00:24
of of many of of the 1 of the 1 of the 1 of the 1 of more of the 1 of my uh 1 of of the of the of the of the of the of the 1 of of of of of of of many of the 1 of the 1 of the 1 of many of the 1 of the 1 of the 1 of the 1 of the 1 of the 1 of many of uh the 1 of of of of of of of the 1 of the 1 of the 1 of the 1 of the of the of the 1 of the 1 of the 1 of the 1 of many of the 1 of the 1 of most of the 1 of the 1 of the womb of move away from the 1 of the 1 of the 1 of the 1 of many of the 1 of the of the 1 of the of of the of the 1 of the ones of the 1 of the 1 of more of the 1 of the 1 of the 1 of the 1 of my home of of most of of the 1 of whom the 1
08:18
of the home of the 1 of the 1 of the 1 of the 1 of me away from the wall of the 1 of many of the 1 of the 1 of the 1 of the 1 of the 1 of the 1 of many of the 1 of the 1 of the 1 of my uh 1 form of of the 1 of the 1 of the 1 of the 1 norm of the 1 of the 1 norm of the 1 of the 1 of the 1 of the 1 of the 1 of the 1 of the 1 of the 1 of the 1 of many of the 1 of the 1 of the 1 of the 1 of whom 1 of the 1 of the 1 of the 1 of the 1 of whom of the 1 of the 1 of the 1 of the womb of 1 of the 1
15:46
norm of the wall of the 1 of the 1 of the 1 of my uh 1 of the 1 of the
16:50
1 of the 1 of the ones from the 1 of the 1 of the 1 of the 1 of the 1 of many of the 1 of the 1 of the 1 of the 1 of many of the of the of the womb of room of 1 of the 1 of whom aware of the 1 of the 1 of the 1 of the 1 of the 1 of of whom the 1 of the 1 of the 1 norm of the 1 of me uh 1 of the 1 of the 1 of more of the warm
21:30
the warm room of the 1 of the 1 of 1 of the 1 of the 1 of more of the 1 of the 1 of many of the 1 of the 1 of whom the 1 of the 1 of the 1 of my uh 1 of the 1 of the 1 of the 1 of whom the 1
24:23
of the 1 of the 1 of the 1 whom the 1 of the 1
25:51
of the 1 of many of the 1 of the 1 of the 1 of the 1 of more of the 1 of the 1 of the 1 of the 1 of 1 of the 1 of the 1 on the 1 of the 1 of the 1 of the 1 of the ones from the 1 of me and the 1 of 1 of the 1 of the 1 of the 1 of the 1 of the 1
30:20
of the 1 of many of whom the 1 of the 1 of the 1 of the 1 of the 1 of the 1 of the 1 of the 1 of more of the 1 of the 1 of the 1 of the 1 of the 1 of the 1
32:39
1 of the of the of the of the 1 whom the of 1 of the warm the warm the warm room of more of 1 of the 1 of the 1 of the 1 of the 1 of the 1 of the 1 of the 1 of norm of the 1 of the 1 norm of most of the of the of the 1 of the 1 of the 1 norm of the womb room of the 1 of many of the 1 of the 1 of the 1 of the womb of many of the 1 of the 1 of the 1 of the womb of the 1 1 of the of whom the warm away from the 1 of the 1 of the 1 of the ones from the 1 of most of the 1 of the 1 of more of the 1 of the 1 of the 1 of the 1 of many of the 1 of the 1 of the 1 norm of the 1 whom the 1 of the 1 of the 1 whom the 1 of the of the of the 1 of the 1 of the 1 of the 1 norm of the 1 of the 1 norm of most of the 1 of the 1 of the 1 of the 1 norm of the 1 of the 1 of whom of many of the 1 of my home of the 1 of the 1 of the 1 norm of the 1 of 1 of the room of of the wall of the room of the