by David Stokes | Jun 16, 2025 | Insight for DBAs, PostgreSQL
This blog was first authored in 2022. We’ve updated it in 2025 for clarity and relevance, reflecting current practices while honoring their original perspective. PostgreSQL 15 introduced the MERGE command, a feature that has a big impact on how you can manage data...
by Sergey Pronin | Jun 11, 2025 | Cloud, Percona Software, PostgreSQL
This post was originally published in 2023, and we’ve updated it in 2025 for clarity and relevance, reflecting current practices while honoring its original perspective. Running PostgreSQL on Kubernetes promises flexibility, but storage decisions can quickly make or...
by David Quilty | Jun 10, 2025 | Insight for DBAs, PostgreSQL
This blog was first authored in 2024 and we’ve updated it in 2025 for clarity and relevance, reflecting current practices while honoring the original perspective. PostgreSQL is known for its reliability and feature-rich environment, but as with any database, when...
by Anup Gupta | Jun 9, 2025 | Insight for DBAs, PostgreSQL
Patroni is a Python-based template for managing high availability PostgreSQL clusters. Originally a fork of the Governor project by Compose, Patroni has evolved significantly with many new features and active community development. It supports integration with various...
by David Quilty | Jun 6, 2025 | Insight for DBAs, Percona Software, PostgreSQL
If your database is getting slower, your users don’t care why. They just want it to work. Meanwhile, you’re stuck dealing with the symptoms: sluggish apps, spiking resource usage, and support tickets piling up faster than your monitoring alerts can handle....
by David Quilty | May 27, 2025 | Insight for DBAs, PostgreSQL
Something’s slowing your database down, and everyone feels it. Dashboards drag. Reports run late. Engineers start rebooting services just to buy time. Nobody’s saying “the database is broken,” but something isn’t right. You know there’s a problem. What you don’t have...
by Lalit Choudhary | May 14, 2025 | Insight for DBAs, PostgreSQL
PgBouncer is a lightweight external connection pooler that can be introduced between an application and a PostgreSQL database. It manages its own user authentication and has its own database for users, and uses auth_type options to authenticate users. This blog post...
by David Quilty | May 9, 2025 | Percona Software, PostgreSQL
You don’t have time for database downtime. Whether you’re managing a high-traffic application, supporting business-critical transactions, or ensuring real-time analytics stay online, the last thing you need is a PostgreSQL failure that grinds everything to...
by Ibrar Ahmed | Apr 30, 2025 | Insight for DBAs, PostgreSQL
This blog was first authored in 2020. We’ve updated it in 2025 for clarity and relevance, reflecting current practices while honoring their original perspective. PostgreSQL offers a rich set of indexing features, and while there’s no shortage of articles explaining...
by Pablo Svampa | Apr 30, 2025 | Benchmarks, Insight for DBAs, Insight for Developers, PostgreSQL
Indexing is one of PostgreSQL’s most effective tools for improving query performance, but like any powerful tool, it can cause real problems when overused. A while ago, my colleague Jobin wrote a blog post exploring the negative side effects of over-indexing in...
by David Quilty | Apr 25, 2025 | Percona Software, PostgreSQL
You’re likely racing to enhance your applications with more intelligent, data-driven capabilities, whether through AI-powered models (which have moved into “must implement now!” territory), advanced search functions, real-time fraud detection, or...
by Ibrar Ahmed | Apr 25, 2025 | Insight for DBAs, PostgreSQL
This blog was first authored by Ibrar Ahmed in 2023. We’ve updated it in 2025 for clarity and relevance, reflecting current practices while honoring their original perspective. PostgreSQL’s flexibility gets a lot of credit. Performance too. But what really sets it...
by David Quilty | Apr 18, 2025 | Cloud, Insight for DBAs, PostgreSQL
Remember when running databases in Kubernetes felt like a gamble? When unpredictable storage performance and complex state management made stability a constant battle? Thankfully, those days are largely behind us. With better tools, smarter operators, and field-tested...
by David Quilty | Apr 15, 2025 | Insight for DBAs, Insight for Developers, PostgreSQL
This post was originally published in January 2024 and was updated in April 2025. Thinking about a PostgreSQL upgrade? Here’s what trips teams up (and how to get it right) Most upgrades are welcome. New phone OS? Great. Window seat on a flight? Even better....
by Ibrar Ahmed | Apr 5, 2025 | Insight for DBAs, PostgreSQL
This blog was first authored by Ibrar Ahmed in 2020. We’ve updated it in 2025 for clarity and relevance, reflecting current practices while honoring their original perspective. If you’re running PostgreSQL and suddenly hit an error you don’t recognize, you’re in...
by David Quilty | Apr 5, 2025 | Insight for DBAs, PostgreSQL
Thinking about moving to PostgreSQL? You’re not the only one. Maybe it’s the licensing fees your current database keeps hiking year after year. Maybe performance is starting to lag just when you need it most. Or maybe you’re just tired of asking permission to make...
by Ibrar Ahmed | Apr 5, 2025 | PostgreSQL
This blog was first authored by Ibrar Ahmed in 2020. We’ve updated it in 2025 for clarity and relevance, reflecting current practices while honoring their original perspective. Picture this: you’re running what should be a simple query, and PostgreSQL returns...
by Pete Scott | Apr 2, 2025 | Database Trends, Percona Software, PostgreSQL
This blog was first authored by Pete Scott in 2023. We’ve updated it in 2025 for clarity and relevance, reflecting current practices while honoring their original perspective. If you’re hearing more about PostgreSQL these days, you’re not alone. Maybe your team is...
by David Quilty | Apr 1, 2025 | Benchmarks, Cloud, Insight for DBAs, Percona Software, PostgreSQL
You know that moment when your team finally decides to move your PostgreSQL databases to Kubernetes? Everyone’s excited about the scalability and flexibility, but then someone asks the question that keeps you up at night: “Which storage are we going to...
by Ibrar Ahmed | Apr 1, 2025 | Insight for DBAs, PostgreSQL, Security
This blog was first authored by Ibrar Ahmed in 2021. We’ve updated it in 2025 for clarity and relevance, reflecting current practices while honoring their original perspective. You think your PostgreSQL setup is secure. That is, until you actually try to document it....
