1
Why I Enjoy PostgreSQL – Infrastructure Engineer's Perspective
Why I enjoy PostgreSQL - Infrastructure Engineer's Perspective
Shayon Mukherjee
Everything, everywhere - always in progress
- Popular posts
- 6
- Total points
- 909
- HN comments
- 628
- Rank
- #2,449 personal
Visit shayon.dev → RSS feedOn Hacker News Jan 2022 – Feb 2026
Databases & Data 5Systems & Performance 2Software Engineering 2Infrastructure & DevOps 2Security & Privacy 1
2
Database mocks are not worth it
Testing against a real database uncovers hidden pitfalls that can appear as the application matures
3
Non blocking and zero downtime ALTER statements in PostgreSQL with pg-osc
pg-osc is a CLI tool for making non-blocking, zero downtime schema changes in PostgreSQL
4
Do you really need foreign keys?
Foreign keys are a bit like that well-intentioned friend who insists on double-checking everything you do. They’re often recommended as a must-have for enforcing referential integrity checks in your database.
5
Selective async commits in PostgreSQL – balancing durability and performance
Safely leverage PostgreSQL's asynchronous commit for significant performance gains