Databases

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

Using YugabyteDB Geo-Partitioning to Ease Global Expansion & Achieve Regulatory Compliance

Using YugabyteDB Geo-Partitioning to Ease Global Expansion & Achieve Regulatory Compliance

Geo-partitioning with YugabyteDB (versus standing up separate PostgreSQL instances per region) is the ideal solution for use cases that require cross-region data access, faster time to market, and easy deployment management.
Read this blog to discover the pitfalls of standing up separate PostgreSQL instances per region and the advantages of using geo-partitioning in YugabyteDB.

Read more

YugabyteDB Resiliency vs. PostgreSQL High Availability Solutions

YugabyteDB Resiliency vs. PostgreSQL High Availability Solutions

Database High Availability has traditionally been achieved through enhanced and automated disaster recovery solutions. Although these measures reduce the impact of failures, they still result in complete downtime for the application during the failover process. In this blog, we compare this approach with cloud-native solutions for high availability, focusing on resiliency built directly into the database.

Read more

When Should You Use Distributed PostgreSQL For Gen AI Apps?

When Should You Use Distributed PostgreSQL For Gen AI Apps?

Postgres is increasingly being used for Gen AI workloads, but users have reported scalability and performance issues, data privacy challenges and high availability concerns. Before you choose a scalable, HA, vector database instead, try running distributed PostgreSQL. Read our new blog to discover when and how to use distributed PostgreSQL for Gen AI workloads.

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