PostgreSQL Support & Consulting Since 1997

What We Do

PgLTS

PgLTS is a PostgreSQL distribution for the mature enterprise. Supporting EOL PostgreSQL version 12 and up, Command Prompt ensures that your data stack stays reliable and secure until you are ready to upgrade.

Learn more

Professional Services

For 26 years we have focused on building mutual success with Postgres and Open Source deployments including architecture, consulting, automation and optimization.

Learn more

24x7x365 Support

We bring white glove service to our clients with Enterprise Wide 24x7x365 support for Postgres and the Full Stack.

Learn more

Audax/PgManage

The Control Center for your Data Stack. Visualize performance and manage configurations without Command Line friction with our GUI administrator for multiple databases.

Learn more

More about us

Let the numbers speak

Items managed

Issues solved

Our clients say

Our preliminary data is showing that the new servers coupled with Postgres 10 are incredibly fast. Our peak traffic was known to tax our previous periodically throughout the morning. This morning our biggest spike was 7% utilization, and that only lasted a few seconds! Thanks for the help getting us configured correctly!

John Reeve

Pelago

I appreciate the excellent support you and the CMD team deliver. I had the pleasure of making an excellent recommendation to one of your potential new customers. I hope the sale was made and you got the new business. I am happy to assist with helping JD and the CMD team with Globitech's excellent experiences of PostgreSQL and Command Prompt support.

Bryan Ward

Globitech Inc.

Command Prompt is about building relationships. That is why we are the oldest successful PostgreSQL company in North America. That is why we maintain profitability. That is why we have active clients that have participated in the PostgreSQL journey longer than many other PostgreSQL companies have existed. Contact us todayand experience a new level of stability within your infrastructure.

Joshua D. Drake

Command Prompt, Inc.

This all makes sense to me. Thanks for documenting it. I think the changes you made here and to the postgresql.conf have made a significant difference. Wednesday is one of our higher traffic days and the database seemed to perform better today than I've seen it do in a long time. We've still got a lot to do, but thank you for saving my butt here!

Heather Johnson

New York Post

WhiteHat Security utilizes PostgreSQL and Ubuntu in a high velocity OLTP environment with HP and Apple hardware. Their database is quickly growing to the multi-terabyte range and they have partnered with The PostgreSQL Company, Command Prompt, Inc., to insure the highest levels of performance.

Bill Pennington, CISSP, CCNA

WhiteHat Security Inc.

Early morning in March of 2023, we received an alert that our RDS instance was down due to the disk attempting to expand too many times over a short period, triggering a disk expansion rate limit on AWS. Before I could finish writing my ticket to Command Prompt, Justin called me directly to inform me, in detail, about the issue. We worked together on an outside-the-box solution that had our production DB back up and running within the hour.

Josh Deere, VP, Development Operations

SchoolStatus

Command Prompt is precisely that - prompt. Their support, expertise, and availability have guaranteed near-perfect uptime of our databases.

Dan Moore, Integrated Library System Administrator

King County Library System

Beyond the 25% Rule: shared_buffers Behavior in Large-Memory PostgreSQL

Tuning shared_buffers isn't just about peak throughput — it's about how much CPU and disk I/O a system consumes per unit of work. The 25% default can require up to 5x more disk I/O than very low or very high allocation. Part 1 of 3.

Postgres and Open Source Deserve a Partner, Not a Vendor

What We Do

PgLTS

Professional Services

24x7x365 Support

Audax/PgManage

Let the numbers speak

Our clients say

WhiteHat Security utilizes PostgreSQL and Ubuntu in a high velocity OLTP environment with HP and Apple hardware. Their database is quickly growing to the multi-terabyte range and they have partnered with The PostgreSQL Company, Command Prompt, Inc., to insure the highest levels of performance.

Command Prompt is precisely that - prompt. Their support, expertise, and availability have guaranteed near-perfect uptime of our databases.

Beyond the 25% Rule: shared_buffers Behavior in Large-Memory PostgreSQL

Recent blogs

Parquet and Iceberg: An Overview

Beyond the 25% Rule: shared_buffers Behavior in Large-Memory PostgreSQL

The Architect

Romancing the Claude

Your company is not AI ready