Postgres JSONB vs Separate Tables: Real Benchmarks
Change one integer inside an 8 KB JSONB document and PostgreSQL 17 writes about 16,300 bytes of WAL. Change the same integer when it lives in its own column and it writes 294 bytes. That 55x gap…
10 articles tagged with #Performance
Change one integer inside an 8 KB JSONB document and PostgreSQL 17 writes about 16,300 bytes of WAL. Change the same integer when it lives in its own column and it writes 294 bytes. That 55x gap…
A 64 GB cache node holding 41 GB of live data should not be evicting anything. Yet stats on a memcached instance in exactly that state can report evictions climbing by 12,000 per second while…
Discover how we achieved 5x request throughput and 60% latency reduction using Laravel Octane in production—without touching our server setup or rewriting code.
Discover PostgreSQL's overlooked performance features that reduced our query times by 85% and saved $12k monthly in infrastructure costs. Real benchmarks, production patterns, and gotchas included.
Reproduce five scaling failures on one laptop (exhausted connection pools, missing timeouts, cache stampedes, N+1 queries and slow request paths) with runnable scripts, measured output and fixes.
Make a Laravel 12 app stateless with Redis, fix a slow query with EXPLAIN, stop cache stampedes, and watch a Kubernetes HPA scale it on kind.
Learn the hard-won lessons from scaling a Laravel app to 100k+ users. Real performance numbers, database optimization, caching strategies, and infrastructure decisions that actually worked.
Build a reusable React lazy loading hook with IntersectionObserver, then see Chrome-measured requests, LCP and pop-in against native loading="lazy" and React.lazy.
After migrating three production apps to RSC, I learned the hard way when server components shine and when they become a liability. Here's what the docs won't tell you about choosing between server a…
Reproducible benchmarks of a PostgreSQL partial index, BRIN index, expression index and INCLUDE index on 3M rows, with sizes, plans and when each does nothing.