This web content summarizes details and sources related to Postgres table-level and row-level locking, as well as zero-downtime migrations using Django and Postgres. The information provided is derived from tests and can be considered true to some extent. One notable test involves determining the locks taken by an arbitrary SQL statement through runtime inspection. The content offers insight into database locking mechanisms and migration strategies, providing valuable information for developers working with Postgres and Django.
Controversial information: None highlighted
Surprising/unique/clever content: Ability to determine locks taken by SQL statement through runtime inspection.
https://leontrolski.github.io/pglockpy.html