The new feature brings single-node PostgreSQL execution and classic distributed SQL execution together. While single-node PostgreSQL offers local execution for low latency, but no distributed execution, classic distributed SQL, on the other hand, offers distributed execution for resilience and scale, but with higher latency.
“Midsize applications running on single-node database instances can now effortlessly move to a fully distributed database environment,” Ranganathan explained, reiterating that as the app grows, YugabyteDB shifts seamlessly to fully distributed mode to provide the massive scaling benefits of distributed SQL, without needing to change databases.
Further, the company said that it had added a new distribution-aware cost-based optimizer (CBO) to the latest version of YugabyteDB in order to deliver PostgreSQL-like performance for any application.