Postgres and Open Source Experts

Anytime. Anywhere. Since 1997.

Blog

PostgreSQL 18: Revolutionary Performance Boost Now Available

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.

Why Growing Teams Are Moving from Aurora to RDS or EC2: Cost and Control Considerations on AWS

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: Enterprise Edition Released

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.

Lessons from the CISA and USCG Joint Advisory: What “No Breach” Still Reveals

The July 31st advisory from CISA and the U.S. Coast Guard (AA25-212A) is less about what happened and more about what could have. A proactive threat hunt at a U.S. critical infrastructure organization revealed no active compromise, but it uncovered systemic weaknesses like insecure credentials, unrestricted remote access, and insufficient monitoring. This is a textbook case of “security theater”: policies and tools on paper, without enforcement in practice. The takeaway is clear: no evidence of compromise is not the same as no risk.

Upgrading PostgreSQL and Citus for Enhanced Database Functionality

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.

Lessons From The Road: More Intention, Less Autopilot

How much of our time is spent on autopilot?

Most people can agree that our internal autopilot systems enable us to be efficient and effective. It allows us to do things like listen to a client while trying to find the bug they are describing in the source code. Or make dinner while holding a conversation. Or even have Spiderman-like reflexes when a child falls out of a chair across …

Service Monitoring via Hazard Analysis White Paper

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.

Critical Security Alert: Immediate Action Required for Self-Hosted SharePoint Servers (CVE-2025-53770)

A critical, newly disclosed, and actively exploited vulnerability, CVE-2025-53770, affects all self-hosted / on-premises Microsoft SharePoint Server versions. This critical issue does not impact SharePoint Online (Microsoft 365).

The exploit enables attackers to:

  • Bypass authentication
  • Install persistent backdoors
  • Launch ransomware
  • Steal sensitive data

Immediate Steps to Take:

  • Patch all on-premises SharePoint servers immediately following Microsoft guidance
  • Disconnect unpatched servers from the Internet immediately
  • For versions older than SharePoint 2016: …

Lessons from the Road: What actually matters

Amid life's many demands, what truly matters? Inspired by her sister‑in‑law’s final words—"It is well"—Amanda Nystrom invites us to define what it means to live without regret.

Part 6: Prevention and Monitoring Strategies

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.