3 ms·

I'm surprised Postgres has continued to be popular despite having multi-master or sharding support.

• zozbot234 6y ago
  Postgres supports table partitioning and foreign data wrappers (used for accessing remote SQL databases) which can be used to set up sharding as described in the postgres docs.
• markdown 6y ago
  > multi-master Wow, so oppressive. #DecoloniseSQL
• sitharus 6y ago
  Why? Very few products need sharding, let alone multi-master. Sure a popular social media platform would, but most development in the world is for small to medium scale line-of-business apps. Postgres is _fantastic_ for these.
  • plaur782 6y ago
    This is the key point we see - most applications just do not generate write traffic that is beyond what a recent release of Postgres can handle.
• speedgoose 6y ago
  It's because most developers don't need multi-primary databases, which have downsides too.
• sharadov 6y ago
  I manage a large sized Postgres farm with 100s of instances, and there has been one case where we need multi-master, and I went with Galera cluster for MariaDB. You can shard using the citus extension for Postgres.
  • plaur782 6y ago
    Depending on requirements, there are an increasing number of options for "active-active" Postgres deployments. A colleague wrote this on a federated active-active configuration on Kubernetes: https://info.crunchydata.com/blog/active-active-postgres-federation-on-kubernetes https://info.crunchydata.com/blog/active-active-postgres-fed...
• oneweekwonder 6y ago
  Was using aws pg service and wanted our prod@aws synced to dev/backup@localhost and found Bucardo[0] to do a great job. "Bucardo is an asynchronous PostgreSQL replication system, allowing for both multi-master and multi-slave operations" [0]: https://bucardo.org/Bucardo/ https://bucardo.org/Bucardo/