[untitled]4 points·by ioololaa·il y a 3 mois·0 comments2 commentsPost comment[–]mockbolt·il y a 3 moisreplythis 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·il y a 3 moisreplyHonestly 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