Tag Collection

#backend

Showing 2 articles in this topic

RSS Feed
PostgreSQL Indexing Under Fire: B-Tree, BRIN, and Partial Indexes for 20M+ Rows

PostgreSQL Indexing Under Fire: B-Tree, BRIN, and Partial Indexes for 20M+ Rows

Stop putting standard B-Trees on every column. How swapping to BRIN and partial expression indexes saved 18 GB of RAM and 4x’d ingestion throughput on a production cluster.

3 min read
#postgresql #databases #backend #performance
Hunting Down Silent Memory Leaks in High-Throughput Node.js Microservices

Hunting Down Silent Memory Leaks in High-Throughput Node.js Microservices

A post-mortem on debugging an elusive 12 MB/hour heap leak under 4,500 req/sec load. V8 heap snapshots, weak references, closure traps, and event listener leak detection.

3 min read
#nodejs #backend #performance #debugging