WRITINGS
Independent technical blogs, architectural deep-dives, and system design philosophies.
Independent technical blogs, architectural deep-dives, and system design philosophies.
An exhaustive architectural analysis of Relational schema engineering, partial indexes, BRIN vs B-Tree, connection pool multiplexing, and ORM query compilation. Specifically investigating why naive orm abstractions cause massive sequential scans and connection storms at 100,000 qps, and how to engineer physical postgres schemas for sub-millisecond execution.