The Distributed SQL Blog

Distributed SQL Summit 2024: Postgres Without Limits

Distributed SQL Summit 2024: Postgres Without Limits

Register now for the Distributed SQL Summit on Nov 12th. This hybrid event gives the distributed SQL community, customers, partners, and industry leaders a forum to explore how they can eliminate complexity and embrace a modern data ecosystem. Join us to discover the latest distributed SQL innovations and use cases, plus the chance to share your experiences (and questions) with peers and industry experts.

Read more

Exploring the New YugabyteDB Cost Based Optimizer

Exploring the New YugabyteDB Cost Based Optimizer

A key challenge in a distributed SQL database is achieving high throughput and consistency for both write and read operations. This blog explores the new YugabyteDB Cost Based Optimizer (CBO), an essential piece of the puzzle to achieve high throughput for read operations. It highlights the challenges we tackled while developing the CBO, and details how some of the most impactful aspects of YugabyteDB are modeled.

Read more

Delivering Postgres Parallel Queries in YugabyteDB

Delivering Postgres Parallel Queries in YugabyteDB

Delivering query parallelism is a key step on our journey to narrow the performance gap between Postgres and YugabyteDB. This blog examines the Postgres Parallel Query feature supported and available in the latest version of YugabyteDB. Click to discover how query parallelism is implemented and functions in Postgres, and what we did to ensure the feature works in YugabyteDB.

Read more

How to Implement Bitmap Scans on Distributed PostgreSQL

How to Implement Bitmap Scans on Distributed PostgreSQL

A key part of our effort to achieve full Postgres compatibility is providing support for bitmap scans (a scan type that combines multiple indexes). This blog deep dives into the high-level strategy of bitmap scans and examines how Postgres implements bitmap scans, how we adapted bitmap scans to work for YugabyteDB, and areas where YugabyteDB bitmap scans go beyond vanilla Postgres.

Read more

Introducing YugabyteDB with Enhanced Postgres Compatibility: Postgres Without Limits

Introducing YugabyteDB with Enhanced Postgres Compatibility: Postgres Without Limits

We are thrilled to announce powerful new capabilities and architectural enhancements — collectively called enhanced Postgres compatibility — that allow a broader range of Postgres apps to run on YugabyteDB. This latest development makes YugabyteDB the perfect database for companies building cloud-native applications and modernizing existing applications to a cloud-native RDBMS. Click to discover what’s new in YugabyteDB and why we decided to build these new capabilities.

Read more

How to Architect a Robust Data Pipeline with Microsoft Fabric and YugabyteDB

How to Architect a Robust Data Pipeline with Microsoft Fabric and YugabyteDB

Integrating Microsoft Fabric Data Pipelines with YugabyteDB using incremental data loading is an efficient and scalable solution for managing large datasets. This blog explores how you can easily ingest data from YugabyteDB and process and store it in Microsoft Fabric Lakehouse using Microsoft Fabric’s Data Pipeline. The result is seamless data flow, centralized storage, and robust analytics capabilities, enabling effective data-driven decision-making.

Read more

Embracing Chaos: Testing Resiliency and Consistency in YugabyteDB

Embracing Chaos: Testing Resiliency and Consistency in YugabyteDB

Jepsen tests and a chaos-driven testing framework play a crucial role in identifying and addressing vulnerabilities. However, traditional testing methods fall short for cloud-native applications and distributed systems. This blog provides the latest Jepsen updates for YugabyteDB, as well as sharing information on additional in-house built frameworks for resiliency and consistency testing that go far beyond Jepsen.

Read more

Explore Distributed SQL and YugabyteDB in Depth

Discover the future of data management.
Learn at Yugabyte University
Get Started
Browse Yugabyte Docs
Explore docs
PostgreSQL For Cloud Native World
Read for Free