Every story tagged Database Management, curated for CIOs and IT leaders — ranked by source credibility, engagement, and freshness.
6 stories · open in the command center
ClickHouse achieved 4x throughput improvement in PgBouncer connection pooling by deploying a fleet of processes across all available CPU cores using kernel-level load balancing (so_reuseport), rather than relying on a single-threaded process that leaves compute resources idle. This architectural optimization eliminates the pooler as a performance bottleneck, enabling organizations to handle significantly higher database connection loads (336k vs 87k transactions/sec) without infrastructure overprovisioning. For IT leaders managing Postgres deployments at scale, this demonstrates that connection pooling architecture directly impacts database performance and infrastructure ROI, with implications for both cost optimization and application scalability.
PostgreSQL has evolved into a comprehensive database platform capable of handling diverse workloads—from traditional OLTP to message queues, search, time-series, and graph data—through extensions and native features, potentially reducing the need for multiple specialized database systems. For CIOs and technology leaders, this consolidation opportunity can significantly simplify infrastructure complexity, reduce operational overhead, and lower total cost of ownership by standardizing on a single, mature, open-source platform rather than maintaining a polyglot database architecture. However, success requires careful evaluation of specific performance and scaling requirements, as well as investment in PostgreSQL expertise and tooling to realize these benefits.
SQL remains a durable, foundational technology that has maintained relevance across three decades of IT evolution, demonstrating exceptional longevity and return on investment compared to rapidly changing frameworks and languages. For IT organizations, this underscores the strategic value of prioritizing skills and infrastructure built on proven, stable technologies that reduce technical debt and migration costs over enterprise lifespans. The persistence of SQL suggests that foundational data management competencies should be protected and cultivated as core organizational assets rather than treating all technical skills as equally disposable.
Build PGX is assuming maintenance of pgBackRest under the new name pgxbackup, ensuring critical bug fixes, security patches, and compatibility with future PostgreSQL releases for this industry-standard backup solution. This continuity support is essential for organizations relying on pgBackRest in production environments, as it guarantees that a foundational data protection tool will remain functional and secure despite the original maintainer stepping back from active development. IT leaders should recognize this as a strategic shift in PostgreSQL backup management that reduces risk of tool obsolescence while maintaining full backward compatibility with existing backup repositories and configurations.
This article introduces Monastery, an open-source tool for systematically testing transaction isolation level differences between MySQL and MariaDB by automating the Hermitage framework—revealing how different databases handle concurrent transaction anomalies like dirty reads and dirty writes. For IT organizations, understanding these database-specific isolation behaviors is critical for preventing data consistency issues in production systems, particularly when evaluating or migrating between MySQL and MariaDB variants. The findings highlight that despite SQL standards, database implementations diverge significantly in their transaction handling, which directly impacts application reliability and data integrity across different deployment scenarios.
Barman is an open-source, Python-based disaster recovery tool maintained by EnterpriseDB that enables organizations to perform remote backups and recovery of multiple PostgreSQL servers in production environments, reducing data loss risk and recovery time. For IT organizations heavily invested in PostgreSQL infrastructure, Barman provides a cost-effective, actively maintained solution (2.9k GitHub stars, 245 forks) that addresses critical business continuity requirements without proprietary licensing constraints. The tool's 15-year development history and enterprise backing make it a strategic option for strengthening database resilience posture and meeting compliance requirements around backup and recovery capabilities.