6 ms·
I've worked as a support engineer focused on Postgres, and I’ve spent the past two years helping teams debug lock-related issues in production. Lock tooling and
by theotherbrian1 7mo ago
I've worked as a support engineer focused on Postgres, and I’ve spent the past two years helping teams debug lock-related issues in production. Lock tooling and resources are not great as of now. They're either standalone, narrow articles, or are overwhelming, or provide little context to beginners.
So I built the resource I wish I had when I was learning.
It:
- explains locks
- provides demos on how they work
- has a tool that shows what blocks what
- outlines troubleshooting strategies with real world examples
- reviews 7 Postgres monitoring tools
- ramon156 7mo agoVery well written! Definitely learned some new things about PG. Thanks for the resource :)