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.
PgBench is widely used for testing database performance, but its default ‘TPC-B like’ workload may not accurately represent true performance. To achieve more realistic load testing, users can employ custom SQL scripts within PgBench. In this demonstration, we’ll show how these adjustments work using YugabyteDB.
YugabyteDB’s automatic sharding overcomes PostgreSQL’s partition key limitations by allowing date range queries without modifying table partitioning. Thanks to its global secondary indexes, which don’t require a shared sharding key, YugabyteDB enhances performance by distributing rows across multiple servers. Discover the full advantages and see step-by-step instructions in our latest blog post.
Need a database that can accommodate a distributed hybrid deployment model, lower read and write latency, and (most importantly) run the existing PostgreSQL application without an expensive rewrite? See how YugabyteDB was able to meet a logistics company’s performance requirements with no PostgreSQL app changes.
A logistics firm sought to enhance the performance and resilience of their RF system. By implementing a hybrid cloud stretch cluster deployment and strategically positioning data close to users, they successfully lowered latency, aligning with user demands for speed and availability. Explore the detailed approach and outcomes in the following analysis.
Managing large PostgreSQL tables requires partitioning, which can complicate queries. Migrating to YugabyteDB simplifies scaling by automatically sharding and distributing data and minimizing partition reliance. The article includes demos on PostgreSQL’s partitioning limitations and YugabyteDB’s advantages in distributed tables and scalability.
Yugabyte has been recognized in the 2023 Gartner Magic Quadrant™ for Cloud Database Management Systems, highlighting our significant market impact and along with exceptional customer feedback. This achievement reflects our commitment to advancing cloud database management and marks a key milestone.
YugabyteDB 2.20 revolutionizes cloud-native applications with its advanced change data capture, ensuring transactional consistency for a broader range of use cases. This latest release also introduces significant enhancements like OIDC-based authentication and online point-in-time recovery, reinforcing database resilience and performance.
YugabyteDB Managed helps Scout24 meet their complex data needs for “Kotao” with a geo-partitioned, high-availability architecture for global operations. YugabyteDB’s PostgreSQL compatibility and scalable, fault-tolerant design make it a resilient choice for Scout24’s innovative hospitality management tool.
Midoin is leading the charge in the eco-friendly cryptocurrency space. In response to their expansion, Midoin deployed YugabyteDB Managed, leveraging horizontal write scalability and PostgreSQL compatibility to efficiently scale operations and maintain robust security and high availability with low overhead.
