Logo TIB AV-Portal Logo TIB AV-Portal

Improving foreign key concurrency

Video in TIB AV-Portal: Improving foreign key concurrency

Formal Metadata

Improving foreign key concurrency
Title of Series
Number of Parts
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 non-commercial 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.
Release Date

Content Metadata

Subject Area
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.
Metropolitan area network Computer icon Standard deviation Mathematical singularity Maxima and minima Ext functor Density of states Port scanner Value-added network Regular graph Computer animation Revision control Set (mathematics) IRIS-T Energy level Videoconferencing Conditional-access module Extension (kinesiology)
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 Chi-squared distribution Metropolitan area network Serial port Information systems State of matter Density of states Port scanner Euler angles Deadlock Johann Peter Hebel Computer animation Integer Extension (kinesiology)
Computer icon Metropolitan area network Asynchronous Transfer Mode Computer animation Patch (Unix) Military operation Maxima and minima Mass Normal (geometry) Modem
Metropolitan area network Optical character recognition Computer animation Executive information system Information systems Revision control Bit rate Electronic mailing list Normal (geometry) Arm Value-added network Tunis
Metropolitan area network Robot Asynchronous Transfer Mode Computer file Einstein field equations Binary file Bit Single-precision floating-point format Order (biology) Flow separation Computer animation Revision control Implementation
Mathematics Plane (geometry) Computer animation Gradient Revision control Maxima and minima Code Block (periodic table)