Postgres and Open Source Experts

This blog series examines PostgreSQL autovacuum failures, focusing on temp tables and multi-database edge cases that cause bloat, slowdowns, or XID wraparound risks in complex environments.

How often do you take a moment to ask yourself: what is essential in my life? Today? Now? What do I need?

Knowing what is essential enables us to accurately prioritize. Whether from Stephen Covey’s Time Management Matrix in the Seven Habits of Highly Effective People, or any part of the book Essentialism by Greg McKeown, knowing how to prioritize is critical. When we do, we avoid burnout, unhealthy …

For the last four months I have been working in the ‘cozy’ space of a 23’ school bus. Managing a business under the best of circumstances is stressful. Doing it on the road feels near impossible some days. The relocating, the dance of not being in the other’s way, and taking meetings without a proper setup can be frustrating. Not to mention the weather, which over the last four months …

Classic and untrue. It isn’t the DBAs that are the issue. It is the developers and their ego which is driven by the unrealistic expectations of the C-suite that is driven by the ridiculous assertions of the investors that drives this problem. DBAs may be an acquired taste but we are the ones that are constantly cleaning up after the developers who could never learn more than the ORM and think it is better to abstract over a framework to the point of job security through obscurity.

An interesting micro optimization for pg_dump is coming in PostgreSQL 18.

We have seen a shift from the pandemic era work from home mandates to a new back to normal mandate of return to the office. This has caused a lot of frustration from workers. Much of the frustration is valid. Workers feel as if they can do their job more effectively if they work from home and that it provides better flexibility for managing non-work related responsibilities. There have been …

Background

On a recent call, a potential client shared their frustrations with the high costs and limitations of their managed services cloud platform. While reaching out to potential support providers, they often encountered companies that only supported PostgreSQL's community edition or pushed their closed-source editions. This experience highlighted the need for a consulting partner who takes a vendor-neutral approach.

Command Prompt prides itself on integrity, discipline, and excellence. We’re straight …

Command Prompt: Your U.S.-Based Partner for Navigating Compliance in Regulated Industries

As we witness the destruction caused by the California wildfires, we’re reminded of the importance of coming together to support those in need. If you are looking for ways to help, here are a few trusted organizations assisting:

1. California Fire Foundation Wildfire & Disaster Relief Fund - This fund supports immediate relief efforts, as well as long-term recovery and rebuilding initiatives for wildfire-affected communities. Learn more and donate here. …

In Part 1 of this series, we discussed the importance of robust change control policies in managing system modifications and minimizing disruptions. But even the best-planned changes can sometimes go awry. That’s where rollback plans come in as a vital safety net. In Part 2, we’ll focus on the essential role of rollback plans, examining how they minimize downtime, maintain data integrity, and build confidence in your team’s ability …