What Is a “No Data” Application
There are a lot of data-driven lines of business applications that will never have a million rows before they get replaced by something else. I call these « no data » applications because they have so little data the database server will never require many optimizations if any. The default settings are good enough.
Postgres can find any row out of a million on your corporate craptop in a relatively slow docker for windows container in 2 ms with any reasonable index. Oddly enough, it will get much faster performance in the cloud, where the vendor has undoubtedly optimized the database code for their particular infrastructure.