Improving foreign key concurrency

Video thumbnail (Frame 0) Video thumbnail (Frame 12057) Video thumbnail (Frame 23600) Video thumbnail (Frame 25226) Video thumbnail (Frame 32052) Video thumbnail (Frame 36489) Video thumbnail (Frame 38476) Video thumbnail (Frame 45201) Video thumbnail (Frame 48952)
Video in TIB AV-Portal: 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 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.
Identifiers
Publisher
Release Date
2012
Language
English
Producer
FOSSLC

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.
Metropolitan area network Computer icon Standard deviation Mathematical singularity 1 (number) 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 Key (cryptography) 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 Normal (geometry) Key (cryptography) Integer Extension (kinesiology)
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
Metropolitan area network Optical character recognition Executive information system Information systems Bit rate Electronic mailing list Arm Value-added network Computer animation Revision control Key (cryptography) Normal (geometry) Tunis
Metropolitan area network Robot Asynchronous Transfer Mode Computer file 1 (number) Einstein field equations Binary file Bit Single-precision floating-point format Order (biology) Flow separation Computer animation Revision control Key (cryptography) Implementation
Mathematics Plane (geometry) Computer animation Gradient Revision control 1 (number) Maxima and minima Code Normal (geometry) Block (periodic table)
the form of of of of of of of of many
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
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
norm of the wall of the 1 of the 1 of the 1 of my uh 1 of the 1 of the
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
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
of the 1 of the 1 of the 1 whom the 1 of the 1
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
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
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
Feedback