[untitled]4 points·by ioololaa·3 months ago·0 comments2 commentsPost comment[–]mockbolt·3 months agoreplythis is so true in real systemspostgres is “free” but cost comes from bad usage- bad queries → more CPU/I/O - no vacuum → table bloat → more storage - too many connections → wasted memorythen teams just scale infra instead of fixing root causemost cost issues = inefficiency, not scale[–]TheAndruu·3 months agoreplyHonestly any db system is going to be at the mercy of inefficient queries. Regardless of what one uses, optimization will always be necessary
postgres is “free” but cost comes from bad usage
- bad queries → more CPU/I/O - no vacuum → table bloat → more storage - too many connections → wasted memory
then teams just scale infra instead of fixing root cause
most cost issues = inefficiency, not scale