PostgreSQL

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

Does Open Source Work as a Long-Term Business Model?

Does Open Source Work as a Long-Term Business Model?

Cockroach Lab’s decision to move away from open source has reignited the debate on the long-term viability of open source projects, and how companies can find success with this business model. Discover why Yugabyte co-founder Karthik Ranganathan believes that open source (and PostgreSQL) is the future, and the reasons why YugabyteDB is (and will continue to be) fully open.

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

Multimodal Search with PostgreSQL pgvector

Multimodal Search with PostgreSQL pgvector

Large language models (LLMs) have evolved beyond generating text responses to interpreting text prompts. Discover how you can use a multimodal LLM to search your AI applications with PostgreSQL pgvector. This blog examines the architecture, database schema, and code required to build an application that searches recipes by both text and image.

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

Introducing YugabyteDB Aeon

Introducing YugabyteDB Aeon

Having different names for our YugabyteDB DBaaS deployment options has led to some confusion. To make it clear that these are two deployment options of one core product we’ve unified the product name – YugabyteDB Aeon! In this blog, we share the benefits of YugabyteDB Aeon and detail how to choose the best deployment option for your use case.

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