JusDB
Free DB Audit

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.

1 canonical articlesBrowse the complete archive

Popular Searches

Topics:
All Articles(1)Analytics & OLAP(15)Cloud Databases(27)Database Architecture(23)Database Engineering(34)Database Performance(51)Database SRE(33)High Availability(13)MySQL(43)NoSQL Databases(36)PostgreSQL(29)

Latest Articles

Showing 1 of 1 articles

PostgreSQL

PostgreSQL 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
Read
Newsletter

Get the latest database insights and expert tips delivered to your inbox.

Categories
Analytics & OLAPCloud DatabasesDatabase ArchitectureDatabase EngineeringDatabase PerformanceDatabase SREHigh AvailabilityMySQLNoSQL DatabasesPostgreSQL
Popular Tags
MySQL
PostgreSQL
Performance
Optimization
Monitoring
Open Source
Architecture
Replication
Scaling
NoSQL
Stay Connected

Subscribe to our RSS feed for instant updates.

RSS Feed