The Case for Boring Databases
Postgres until you can prove you need something exotic.
Amit Kumar Singh1 min read
#postgres
5 articlesEverything tagged postgres, newest first.
Postgres Indexes: A Field Guide
B-tree, GIN, BRIN, partial — picking the right index for the query.
Amit Kumar Singh1 min read
[Databases]▲ trending
Postgres Connection Pooling, Explained Properly
Why your serverless app exhausts Postgres connections, what a pooler actually does, and how to pick between transaction and session pooling.
Amit Kumar Singh3 min read
Reading an EXPLAIN Plan Without Fear
Turning Postgres query plans into actionable fixes.
Amit Kumar Singh1 min read
Connection Pooling Mistakes
The pool-sizing math everyone gets wrong the first time.
Amit Kumar Singh1 min read