Add to Watchlist

Improving foreign key concurrency

1 views

Citation of segment
Embed Code
Purchasing a DVD Cite video

Formal Metadata

Title Improving foreign key concurrency
Title of Series PGCon 2012
Number of Parts 21
Author Herrera, Álvaro
Contributors Heroku (Provider)
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.
DOI 10.5446/19023
Publisher PGCon - PostgreSQL Conference for Users and Developers, Andrea Ross
Release Date 2012
Language English
Producer FOSSLC

Content Metadata

Subject Area Computer Science
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.
Series
Annotations
Transcript
Loading...
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
Metropolitan area network
Computer icon
Standard deviation
Set (mathematics)
Mathematical singularity
1 (number)
Ext functor
Density of states
Port scanner
Maxima and minima
Regular graph
Computer animation
Revision control
IRIS-T
Energy level
Key (cryptography)
Videoconferencing
Conditional-access module
Extension (kinesiology)
Asynchronous Transfer Mode
Freeware
Mountain pass
Logarithm
Set (mathematics)
Table (information)
Mach's principle
Regular graph
Information systems
Arithmetic logic unit
Multiplication
Chi-squared distribution
Musical ensemble
Metropolitan area network
Serial port
State of matter
Density of states
Port scanner
Euler angles
Deadlock
Johann Peter Hebel
Maxima and minima
Computer animation
Normal (geometry)
Key (cryptography)
Integer
Extension (kinesiology)
Computer icon
Metropolitan area network
Asynchronous Transfer Mode
Patch (Unix)
1 (number)
Mass
Maxima and minima
Computer animation
Military operation
Normal (geometry)
Key (cryptography)
Normal (geometry)
Modem
Metropolitan area network
Optical character recognition
Computer animation
Executive information system
Revision control
Bit rate
Information systems
Electronic mailing list
Key (cryptography)
Normal (geometry)
Tunis
Metropolitan area network
Chatterbot
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
Plane (geometry)
Computer animation
Gradient
Mathematics
Revision control
1 (number)
Code
Normal (geometry)
Block (periodic table)
Maxima and minima
Loading...
Feedback

Timings

  517 ms - page object

Version

AV-Portal 3.8.2 (0bb840d79881f4e1b2f2d6f66c37060441d4bb2e)