3 ms·
You should never move just to move. Postgres has an incredibly long scalability curve just on a single server or small cluster, and after you outgrow that, you
by throwawayapples 5y ago
You should never move just to move. Postgres has an incredibly long scalability curve just on a single server or small cluster, and after you outgrow that, you can move to something clustered that's PG-compatible, either self-hosted or cloud, like CockroachDB, Citus, or a cloud DB like AWS Redshift. Whatever you do, don't lift-and-shift just for the fun of it (or to pump up your resume!)
Unless you are facing extreme variability (changes) in your workload (i.e., growing by 20% per week or something like that), you should probably stay where you are. There's absolutely nothing wrong with stable, predictable organic growth.