Unstructured notes, technical takeaways, and lightbulb moments from random technical videos and talks.
A deep dive into PostgreSQL's process-per-connection model, the max_connections trap, RAM/CPU context switching bottlenecks, back-pressure pooling, and using PgBouncer for scalable database performance.
A detailed breakdown of Diffie-Hellman Key Exchange: covering key exchange intuition, the color mixing analogy, modular arithmetic clock faces, the discrete logarithm problem, and mathematical proofs.
An in-depth guide to the Thundering Herd Problem (Cache Stampede), why synchronized concurrent requests overwhelm backend resources during cache misses or service recoveries, and architectural mitigation techniques like distributed locking, jitter, and request coalescing.