Bestand wählen
Merken

Improving foreign key concurrency

Zitierlink des Filmsegments
Embed Code

Automatisierte Medienanalyse

Beta
Erkannte Entitäten
Sprachtranskript
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
Verklemmung
Prozess <Informatik>
Gewichtete Summe
No-Free-Lunch-Theorem
Extrempunkt
Menge
Computeranimation
Eins
Videokonferenz
Modem
Hochvakuum
MIDI <Musikelektronik>
Neunzehn
Normalvektor
p-Block

Metadaten

Formale Metadaten

Titel Improving foreign key concurrency
Serientitel PGCon 2012
Anzahl der Teile 21
Autor Herrera, Álvaro
Mitwirkende Heroku (Provider)
Lizenz CC-Namensnennung - keine kommerzielle Nutzung - Weitergabe unter gleichen Bedingungen 3.0 Unported:
Sie dürfen das Werk bzw. den Inhalt zu jedem legalen und nicht-kommerziellen Zweck nutzen, verändern und in unveränderter oder veränderter Form vervielfältigen, verbreiten und öffentlich zugänglich machen, sofern Sie den Namen des Autors/Rechteinhabers in der von ihm festgelegten Weise nennen und das Werk bzw. diesen Inhalt auch in veränderter Form nur unter den Bedingungen dieser Lizenz weitergeben
DOI 10.5446/19023
Herausgeber PGCon - PostgreSQL Conference for Users and Developers, Andrea Ross
Erscheinungsjahr 2012
Sprache Englisch
Produzent FOSSLC

Inhaltliche Metadaten

Fachgebiet Informatik
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.

Ähnliche Filme

Loading...
Feedback