alt Hacker NewsNice! What optimizations have you put in llace yo support 150 mil? Just some indexing or other fancy stuff?
Replies
williamdclt • 05/15/2025
You really don't need anything special. 150M is just not that much, postgres has no problem with that.
Obv it depends on your query patterns
You don't need to optimize anything beyond appropriate indices, Postgres can handle tables of that size out of the box without breaking a sweat.