News for hackers. Stuff that matters.
Re:An Overview of Distributed PostgreSQL Architectures by NavinF on Tuesday January 09, 2024 @03:43PM (#38931836)
> In Oracle RAC your cluster is up and running even if just one engine is still alive

So it's not consistent in the CAP Theorem sense. Comparing it with other databases that don't lose writes and don't have split brain issues makes no sense

Re:An Overview of Distributed PostgreSQL Architectures by pi-e-sigma on Tuesday January 09, 2024 @04:08PM (#38932123)
It is always consistent because it is a single storage database with multiple access points. It's not distributed data so CAP theorem doesn't even apply to it.
Re:An Overview of Distributed PostgreSQL Architectures by dikei on Tuesday January 09, 2024 @09:53PM (#38935558)
Oracle RAC is a shared storage system, every database instances write to same datastore, so as long as a transaction is committed by one node, it'll be seen by other nodes.

Of course, the issue with all shared-storage systems is how much it costs to have a reliable and fast shared storage.