MTAR T3D Sessions: Why Postgres Defaults Don’t Match Reality

Welcome back to More Than a Refresh Presents: T3D Sessions. In this Postgres Pet Peeves episode, Greg Dostatni and JD take on a problem most teams run into early but rarely question: default configuration. PostgreSQL ships with hundreds of parameters, many of which are still based on assumptions from decades-old hardware. For new users, that doesn’t feel like flexibility, it feels like noise. Greg breaks down why this creates unnecessary complexity and why, in practice, most teams don’t need to understand all 400 settings. They need to understand the right ones. The conversation also touches on how this has become less of a technical limitation and more of a usability and community challenge over time. They also share a reality many teams experience: it’s not uncommon for “Postgres is slow” to be solved by changing just a couple of parameters. This short session is a grounded look at why configuration feels harder than it should, and what actually matters when tuning Postgres in the real world. 🎧 Listen to all More Than a Refresh episodes: https://www.commandprompt.com/mtar/ 💼 Learn more about Command Prompt: https://www.commandprompt.com 🔧 PostgreSQL Services: https://www.commandprompt.com/services/ 🖥 PgManage – Open Source GUI for PostgreSQL, MariaDB & more: https://www.commandprompt.com/product... 🛡 PgLTS – Long-term support for EOL PostgreSQL: https://www.commandprompt.com/product... 📲 Connect with us: LinkedIn: https://www.commandprompt.com/linkedin Facebook: https://www.commandprompt.com/facebook Twitter/X: https://www.commandprompt.com/twitter BlueSky: https://www.commandprompt.com/bluesky 📬 Contact us: https://www.commandprompt.com/contact...