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

Optimize PostgreSQL for high-write workloads. How replacing B-Trees with BRIN and partial indexes saved 18 GB RAM and quadrupled ingestion throughput.

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

Debug elusive Node.js memory leaks under heavy load. Step-by-step V8 heap snapshot comparison, weak references, closure traps, and event listener cleanups.

3 min read
#nodejs #backend #performance #debugging