How I Engineered a 1.7M Row Product Safety Database to Serve Pages in 66ms on a Single Free VM

Let me tell you what happens when you shove 1.7 million dense PostgreSQL rows onto a 6GB ARM instance and then try to serve real user traffic. Sequential table scans that choke the server for 45 seconds. COUNT(*) queries that make the…