Every story tagged Database Performance, curated for CIOs and IT leaders — ranked by source credibility, engagement, and freshness.
5 stories · open in the command center
PlanetScale has developed a massively parallel backup system for sharded Postgres databases that achieves petabyte-scale backups at speeds exceeding 50 GB/s while maintaining zero production impact through dynamic infrastructure orchestration. This enterprise-grade backup capability—combining filesystem backups, WAL replay from object storage, and hybrid data streaming—reduces backup windows from days to hours and ensures rapid disaster recovery for large distributed databases. For IT organizations managing mission-critical database infrastructure, this approach demonstrates a scalable model for automating backup complexity while protecting production performance and enabling reliable point-in-time recovery.
PostgreSQL can now efficiently handle large-scale queuing workloads—previously thought impossible—by implementing three key optimizations: using SKIP LOCKED for concurrent worker coordination, conditional transaction isolation levels to reduce serialization failures, and streamlined indexing strategies. This enables organizations to consolidate their infrastructure by replacing dedicated queueing systems (RabbitMQ, Redis) with PostgreSQL, reducing operational complexity and maintenance burden while achieving 30K+ workflow executions per second. For IT leaders, this represents a significant opportunity to simplify database architecture, reduce tool sprawl, and lower total cost of ownership for workflow and event-driven systems.
PostgreSQL's LISTEN/NOTIFY feature, long considered unscalable due to a global lock limitation, can actually achieve 60K writes per second with millisecond latency when properly optimized through batching and buffering strategies. This finding is strategically significant for IT organizations seeking cost-effective, low-latency pub/sub and streaming solutions, as it validates PostgreSQL as a viable alternative to specialized message queues for notification-driven architectures. By understanding NOTIFY's actual performance characteristics and implementing appropriate optimization techniques, enterprises can consolidate infrastructure, reduce operational complexity, and leverage existing PostgreSQL investments for real-time data streaming use cases.
PostgresBench is a new open, reproducible benchmark for comparing managed PostgreSQL services using standardized transactional workloads, similar to ClickBench's OLAP methodology. This transparent benchmarking framework enables IT leaders to objectively evaluate Postgres service providers based on performance metrics (TPS, latency) across realistic dataset sizes and concurrency patterns, reducing vendor lock-in risk and supporting data-driven infrastructure decisions. The benchmark's reproducibility and public methodology help CIOs validate performance claims and ensure fair comparisons when selecting managed database providers for transactional workloads.
SurrealDB 3.x demonstrates significant performance improvements with 31% faster CRUD operations and dramatic gains in full-table scans (11,894% improvement over 1.x) compared to previous versions, while benchmarked against production-grade configurations of PostgreSQL, MongoDB, and Neo4j with full disk durability enabled. The multi-model database shows competitive write throughput advantages (1.5× faster than Postgres, 5-7× faster than MySQL) and comparable read performance, positioning it as a viable alternative for organizations evaluating polyglot database strategies. CIOs should evaluate SurrealDB 3.x for workloads requiring transactional multi-model capabilities with strong write performance, though Postgres maintains advantages in complex indexed reads and mature ecosystem maturity.