PostgreSQL Scaling Challenges
Discussions focus on the difficulties of scaling PostgreSQL horizontally, setting up high availability with replication and failover, and experiences with self-hosted versus managed cloud deployments.
Activity Over Time
Top Contributors
Keywords
Sample Comments
Why is it such a big deal, why not just run Postgres yourself?
How do you manage your PostgreSQL deployments?
Have you tried to scale horizontally with Postgres?
10 separate xlarge instances pgsql and never had a single issue in 3 yrs of heavy use. What stories are those?
I think you don't know what you're talking about. Postgres is great if you don't need HA / sharding ect ...
perhaps your DBA friend was operating PG themselves?nowadays postgres in the cloud does all of this for you.
This is great! Have run up some very expensive bills trying to scale postgres. Eager to try this out.
What's the self-hosted Postgres HA story these days?
I think its because the only really viable scaling option for Postgres is vertical scaling. Even just setting up any sort of replication with automatic failover is still a pain (multimaster is not yet built in, master-slave also needs 3rd party failover program...)
They are operating at a scale where you can’t “just use Postgres”