The pg_cron extension serves as a building block for many important PostgreSQL extensions, and enables you to seamlessly schedule automated jobs to monitor and maintain your databases. This blog takes an in-depth look at the pg_cron extension and examines how it works in YugabyteDB.
PostgreSQL continues to dominate the database landscape in terms of adoption and popularity. This blog examines why we believe PostgreSQL will continue to be the top database choice for developers, and how YugabyteDB builds on PostgreSQL’s robust capabilities to support modern enterprise environments.
YugabyteDB’s introduction of in-place index updates is a significant improvement to PostgreSQL’s traditional index and table update mechanics. This blog examines how YugabyteDB modified the storage layer of PostgreSQL and how this enhancement delivers enhanced performance.
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.
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.
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.
We aim to prove YugabyteDB’s enhanced Postgres compatibility by migrating 100 popular open source Postgres applications to YugabyteDB! Discover how you can get involved in the Postgres App Century Challenge.
Conducting extensive and diverse performance and scalability testing ensures that YugabyteDB remains a reliable and high-performance distributed PostgreSQL database, ideal for handling mission-critical, global-scale, applications. This blog gives a deep dive into our comprehensive testing framework.
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.
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.
