The JusDB Database Engineering Blog
Deep dives on PostgreSQL, MySQL, MongoDB and more — performance tuning, high availability, migrations and production war stories from our DBAs.
2 canonical articlesBrowse the complete archive
Popular Searches
Latest Articles
Showing 2 of 2 articles
PostgreSQL Lock Waits: How to Find the Blocking Query and Fix It
Find the session behind a PostgreSQL lock wait with pg_blocking_pids, see why a waiting ALTER TABLE stalls every SELECT, and choose between cancel, terminate, and timeouts.
PostgreSQL18 minOct 27, 2026
ReadPostgreSQL Advisory Locks: Patterns and Pitfalls
Use PostgreSQL advisory locks safely: session vs transaction locks, key choice, singleton jobs, leader election, and the PgBouncer, LIMIT, and lock-table traps.
PostgreSQL18 minOct 27, 2026
ReadNewsletter
Get the latest database insights and expert tips delivered to your inbox.
Categories
Popular Tags
Stay Connected
Subscribe to our RSS feed for instant updates.
RSS Feed