4 ms·
i'm not sure what you mean by pg not being a "distributed" database. it has replication and sharding functionalities that let it run in various clustering confi
by bsaul 6y ago
i'm not sure what you mean by pg not being a "distributed" database. it has replication and sharding functionalities that let it run in various clustering configuration. This looks enough to me to qualify it for aphyr tests.
- takeda 6y agoReplication is read only, so at worst there's only delay when it is set up asynchronously, but ultimately it will be the same as master. The sharding part, do you mean FDW? I don't think PostgreSQL gives any consistency guarantees if you use them.
- bsaul 6y agoha, my bad. I had the feeling pg provided some solution for sharding, but it seems they're all third-party extensions ( like citus/pg-shard)