Postgres and Open Source Experts

PostgreSQL 13 has officially reached end of life as of November 13, 2025, leaving organizations without security patches or community support. Learn your options for upgrading to a supported version—or extending security coverage with PgLTS.

The PostgreSQL Global Development Group has released PostgreSQL 18, delivering the most significant performance improvements in recent years. This latest version transforms database I/O operations and streamlines the upgrade experience for organizations worldwide.

Amazon Aurora PostgreSQL can be a powerful starting point for teams adopting PostgreSQL in AWS. But as usage grows, so do the needs for cost transparency, fine-grained tuning, and architectural flexibility. Here's why more teams are choosing Amazon RDS for PostgreSQL or EC2 as they scale.

PgManage 1.3.1 is now available with fixes across PostgreSQL, Oracle, MariaDB, and SQLite3, plus updated dependencies and UI refinements. Learn what’s new and explore PgManage Enterprise Edition with remote access, multi-user support, and OAuth2 integration.

Discover how a client successfully upgraded PostgreSQL 11 to 15.5 and Citus 8.3 to 12.1 while simplifying extensions, improving scalability, and enhancing performance. This real-world case study highlights the planning, testing, and expertise required to achieve seamless upgrades in distributed environments.

A modern approach to IT observability inspired by hazard analysis. Learn how to improve system reliability, reduce monitoring complexity, and proactively manage service risks through Critical Control Points.

PostgreSQL’s autovacuum is a silent guardian until it fails. In this final post of our autovacuum series, we tackle two often-overlooked scenarios that can lead to database downtime: temp tables in multi-database clusters and lingering sessions with temp tables. Learn practical prevention tactics and monitoring strategies to keep your cluster safe from XID wraparound and emergency shutdowns.

Even in single-database setups, temp tables can quietly lead to major problems. In this post, we break down how long-lived temp tables contribute to XID wraparound risk, why PostgreSQL shuts down to protect against it, and what proactive steps you can take to avoid unexpected downtime.

Part 4 of our PostgreSQL Autovacuum Failure Series explores how session-level temp tables in RDS can silently stall autovacuum—and how we resolved it. Learn why monitoring and visibility are critical in managed cloud environments.

PgManage 1.3 is here with major updates including a redesigned dashboard UI, JSON export, code folding, PostgreSQL 17 support, and more. This release focuses on usability, performance, and cross-database compatibility, enhancing your workflow whether you're using PostgreSQL, MariaDB, MySQL, or others.