Bewegte Bilder
Improving foreign key concurrency
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.
- Standort
-
Hannover TIB
- Umfang
-
35MB, 00:43:16:02 (unknown)
- Sprache
-
Englisch
- Anmerkungen
-
Audiovisuelles Material
- Erschienen in
-
PGCon 2012 ; (Jan. 2012)
- Ereignis
-
Veröffentlichung
- (wer)
-
PGCon - PostgreSQL Conference for Users and Developers, Andrea Ross
- (wann)
-
2012-01-01
- Beteiligte Personen und Organisationen
-
Herrera, Álvaro
Heroku (Provider)
- DOI
-
10.5446/19023
- Letzte Aktualisierung
- 21.04.2026, 10:49 MESZ
Datenpartner
Dieses Objekt wird bereitgestellt von:
Technische Informationsbibliothek (TIB).
Bei Fragen zum Objekt wenden Sie sich bitte an den Datenpartner.
Objekttyp
- zweidimensionales bewegtes Bild
Beteiligte
- Herrera, Álvaro
- Heroku (Provider)
- PGCon - PostgreSQL Conference for Users and Developers, Andrea Ross
Entstanden
- 2012-01-01
Ähnliche Objekte (12)
Improving foreign key concurrency
Debugging concurrency programs in Go
Concurrency in .NET, 2013 version
Message-passing concurrency for Python
Nim concurrency & Parallelism: Past, Present and Future
Python Multithreading and Multiprocessing: Concurrency and Parallelism
JCStress: Eliminating the Nightmare of Debugging Concurrency Problems
Exploiting Concurrency: How I stopped worrying and started threading
Concurrency + Distribution = Scalability + Availability, a Journey architecting Erlang Systems
Structured Concurrency: Finding our way out of callback hell
Project Loom: Fibres, Continuations, and Structured Concurrency for the JVM
From built-in concurrency primitives to large scale distributed computing
Improving foreign key concurrency
Debugging concurrency programs in Go
Concurrency in .NET, 2013 version
Message-passing concurrency for Python
Nim concurrency & Parallelism: Past, Present and Future
Python Multithreading and Multiprocessing: Concurrency and Parallelism
JCStress: Eliminating the Nightmare of Debugging Concurrency Problems
Exploiting Concurrency: How I stopped worrying and started threading
Concurrency + Distribution = Scalability + Availability, a Journey architecting Erlang Systems
Structured Concurrency: Finding our way out of callback hell
Project Loom: Fibres, Continuations, and Structured Concurrency for the JVM
From built-in concurrency primitives to large scale distributed computing
Improving foreign key concurrency
Debugging concurrency programs in Go
Concurrency in .NET, 2013 version
Message-passing concurrency for Python
Nim concurrency & Parallelism: Past, Present and Future
Python Multithreading and Multiprocessing: Concurrency and Parallelism
JCStress: Eliminating the Nightmare of Debugging Concurrency Problems
Exploiting Concurrency: How I stopped worrying and started threading
Concurrency + Distribution = Scalability + Availability, a Journey architecting Erlang Systems
Structured Concurrency: Finding our way out of callback hell
Project Loom: Fibres, Continuations, and Structured Concurrency for the JVM