Tag: #locking
Writing on GPUs, LLMs, MLOps, Kubernetes — and mindset · 3 posts
The Complete Guide to Zero-Downtime Schema Changes: The Lock Level Each DDL Takes and How to Run It Safely
Working from the PostgreSQL 18 documentation, this lays out by grade exactly which lock each DDL statement takes: the eight table lock modes and their conflicts, the lock level of every ALTER TABLE variant, which changes
2026-08-15 · 18 min read #database#postgresql#schema-migration#zero-downtime#lockingThe Complete Guide to Concurrency: The Order in Which You Shrink Shared State
The working order an application designer follows when facing concurrency. First check whether shared state can be removed at all, narrow its scope when it cannot, put atomicity boundaries and locks around what is left,
2026-08-15 · 24 min read #동시성#아키텍처#concurrency#locking#backpressureDiagnosing and Preventing Deadlocks — How to Pin Down the Two Queries from the Log
A step-by-step guide to what you should look at when you hit a deadlock detected error. How to interpret the PostgreSQL deadlock report and the SHOW ENGINE INNODB STATUS output of MySQL line by line so you can pin down w
2026-07-26 · 16 min read #database#postgresql#deadlock#locking#mysql