The brand new characteristic brings single-node PostgreSQL execution and traditional distributed SQL execution collectively. Whereas single-node PostgreSQL provides native execution for low latency, however no distributed execution, traditional distributed SQL, alternatively, provides distributed execution for resilience and scale, however with larger latency.
“Midsize functions operating on single-node database cases can now effortlessly transfer to a completely distributed database setting,” 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 vary databases.
Additional, the corporate mentioned that it had added a brand new distribution-aware cost-based optimizer (CBO) to the newest model of YugabyteDB in an effort to ship PostgreSQL-like efficiency for any utility.
