The 20 MB File That Changed Our Spring Boot API
Embedding file content in JSON turned a modest Spring Boot upload into unpredictable heap pressure—and showed us that content type is also a resource model.
PostgreSQL Used the Index. It Still Processed Millions of Rows.
A PostgreSQL index scan still processed 8.7 million rows because a materialized CTE applied selective filters after an expensive join in production.
PostgreSQL Used the Index. It Still Processed Millions of Rows. Read More »