The brand new characteristic brings single-node PostgreSQL execution and basic distributed SQL execution collectively. Whereas single-node PostgreSQL presents native execution for low latency, however no distributed execution, basic distributed SQL, however, presents distributed execution for resilience and scale, however with greater latency.
“Midsize purposes operating on single-node database situations can now effortlessly transfer to a completely distributed database atmosphere,” Ranganathan defined, reiterating that because the app grows, YugabyteDB shifts seamlessly to totally distributed mode to offer the huge scaling advantages of distributed SQL, without having to alter databases.
Additional, the corporate mentioned that it had added a brand new distribution-aware cost-based optimizer (CBO) to the newest model of YugabyteDB as a way to ship PostgreSQL-like efficiency for any utility.