News for hackers. Stuff that matters.
Re:Pglocks.org by pasxizeis on Sunday May 18, 2025 @08:00AM (#44020680)
Shameless plug: I wrote a tool[1] that executes a given migration against a test database (e.g. in your CI) and reports back what locks it acquired.

The rationale being to have a "lock diagnostics report" commented in your PR's migration file.

It's a prototype and has quite some rough edges and missing functionality, but feedback is more than welcome.

[1] https://github.com/agis/pglockanalyze

Re:Pglocks.org by jononor on Sunday May 18, 2025 @08:38AM (#44020948)
Very practical! Locking is one of the things that can really bite when doing migrations.