$ ls -la /posts
total: 3 (tag #optimization)
$ open windows.mode
SQL Execution Priority and Performance Optimization
How PostgreSQL executes queries internally and how to systematically diagnose and fix slow SQL in production systems
#postgresql#sql#performance
Kadane's Algorithm — Why This Simple Trick Beats Brute Force
Understanding how Kadane's Algorithm solves the maximum subarray problem in linear time with elegant simplicity
#algorithms#dynamic-programming#optimization
Array vs Hash Map Lookup — What Really Wins in Performance?
Why array index lookup often beats hash map lookup in practice, even though both are O(1). Understanding constant factors, CPU cache, and real-world performance.
#data-structures#performance#algorithms