Postgres and Open Source Experts

Anytime. Anywhere. Since 1997.

Blog

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.

Lessons from the Road: Gratitude

I was on the phone with one of my most active clients at Command Prompt when I had to interrupt the call because my dogs somehow opened the bus door and went running after horses. The client and Command Prompt have a good relationship so I wasn’t too worried about the fallout. However, what the client said when I returned to the call and explained the interruption was surprising.

“I …

Part 5: Temp Tables and XID Wraparound in Single-DB Clusters

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.

Lessons from the Road: Know your footprint

What is the weight of your footprint?

What is the cost of your footprint?

One of the most surprising things I experience when I go from a house to a school bus is the sheer amount of waste we as humans produce. From packaging to paper towels to food scraps to everything else I won’t mention here, it’s a lot. When I am stationary at home, my trash hides …

Part 4: Debugging Limitations in RDS and Cloud Environments

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.