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
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