Blogs & Writing

Notes on data platforms, streaming, and AI-native analytics.

Distilled from production systems at Bigtech — practical patterns, trade-offs, and measurement.

Aug 2026 · 7 min PostgreSQL Database

Understanding PostgreSQL Transaction ID Wraparound

A practical guide to 32-bit XID limits, MVCC tuple freezing, autovacuum parameters, production monitoring queries, and emergency recovery.

Read article → Tanay Karmarkar