~/tag/performance

#performance

7 articles

Everything tagged performance, newest first.

How to use Java virtual threads in backend APIs without overloading databases, pools, or downstream services.

Amit Kumar SinghAug 16, 20262 min read

[Databases]▲ trending

A practical tour of PostgreSQL 18 features such as async I/O, skip scans, uuidv7, retained planner statistics, and richer EXPLAIN output.

Amit Kumar SinghAug 16, 20262 min read

Measuring caching effectiveness past the vanity number.

Amit Kumar SinghJun 9, 20262 min read

B-tree, GIN, BRIN, partial — picking the right index for the query.

Amit Kumar SinghJun 8, 20262 min read

Practical levers for trimming that first-request latency.

Amit Kumar SinghJun 6, 20262 min read

Turning Postgres query plans into actionable fixes.

Amit Kumar SinghJun 5, 20262 min read

Cache-aside, write-through, and write-behind — what each one guarantees, where they break, and how to think about the hardest part: invalidation.

Amit Kumar SinghMay 30, 20263 min read