Developers can now store, index and query vectors in PostgreSQL using pgvector, eliminating the need for a dedicated vector database. This blog deep dives into pgvector, and explains how to store text embeddings as vectors, execute similarity search, choose between indexes, and scale with distributed SQL.
In this blog post, we examine how you can migrate data and schema from an existing PostgreSQL database using YugabyteDB Voyager. With a focus on data modeling for appropriate data distribution, we explore two different migration approaches: “Lift” and “Lift & Shift.”
The enhanced YugabyteDB Kubernetes Operator significantly simplifies the deployment, management, and scaling of YugabyteDB in cloud-native environments. Discover how it automates complex operations to enhance reliability and allows developers and operations teams to focus more on development and less on infrastructure management.
Discover why YugabyteDB is moving beyond PostgreSQL 11 and the challenges and solutions involved in upgrading to PostgreSQL 15 (and beyond). Learn how our engineering team is bringing the most popular PostgreSQL features to YugabyteDB, to deliver a reliable, scalable, highly available, and secure distributed SQL database.
YugabyteDB 2.19.2 introduces full support for Read Committed Isolation with Wait-On-Conflict, essential for PostgreSQL users looking to seamlessly lift-and-shift applications to a distributed environment. This feature ensures parity with PostgreSQL while leveraging the scale and resilience of YugabyteDB, simplifying the transition for users.
YugabyteDB 2.19 introduces a revolutionary built-in Connection Manager, transforming PostgreSQL’s well-documented connection challenges into strengths. The enhanced manager boosts connection creation speeds up to 20x and supports up to 5x more connections, all while maintaining consistent throughput.
Discover why YugabyteDB doesn’t support PostgreSQL extensions pg_repack and pg_buffercache. While YugabyteDB leverages the Postgres query layer, its unique approach to the storage layer makes certain extensions unnecessary.
Introducing PgCompute—a client-side extension for PostgreSQL aimed at revitalizing the use of database functions by allowing developers to create and optimize them seamlessly within their preferred IDE and programming language.
PostgreSQL offers robust features but has certain limitations in scalability, replication, resilience (and more). YugabyteDB addresses these issues through distributed design, storage efficiency, and transaction handling, providing a comprehensive solution when high availability, ACID, and scale are mandatory.
Distributed SQL offers greater scalability, availability, and geo-distribution of data compared to PostgreSQL, but it is important to understand the differences in behaviors between the two systems in order to make the most of your distributed SQL database.
