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....
by Ibrar Ahmed | Apr 1, 2025 | Insight for DBAs, Open Source, PostgreSQL
This blog was first authored by Ibrar Ahmed in 2018. We’ve updated it in 2025 for clarity and relevance, reflecting current practices while honoring their original perspective. If your PostgreSQL performance seems to be lagging, you’re not imagining things. It...
by Jan Wieremjewicz | Mar 28, 2025 | Open Source, PostgreSQL, Security
PostgreSQL is, without a doubt, one of the most popular open source databases in the world. Why? Well, there are many reasons, but if I had to pick just one, I’d say it’s extensibility. PostgreSQL isn’t just a database; it’s an ecosystem of extensions that can...
by Robert Bernier | Mar 18, 2025 | Insight for DBAs, Open Source, Percona Software, PostgreSQL
This post was originally published in December 2023 and was updated in March 2025. These days, there’s significant industry interest in moving database systems to PostgreSQL. Often, these are greenfield projects focusing on design and architecture. However,...
by Anil Joshi | Mar 13, 2025 | Cloud, Insight for DBAs, PostgreSQL
In this brief blog post, we will talk about Barman cloud utilities, which greatly ease the process of storing backups on cloud platforms like GCP, AWS, Azure, etc. Backups are of paramount importance, and in PostgreSQL, we also need to retain the WAL files, which can...
by Lalit Choudhary | Mar 12, 2025 | Insight for DBAs, PostgreSQL
Patroni has a REST API that allows HAProxy and other kinds of load balancers to perform HTTP health checks. This blog post explains how HAProxy uses Health check endpoints with Patroni and how to debug the status issue. HAProxy and Patroni setup: Sample configuration:...
by Pete Scott | Mar 7, 2025 | Insight for DBAs, PostgreSQL
This post was originally published in July 2023 and updated in March 2025. With the average cost of unplanned downtime running from $300,000 to $500,000 per hour, businesses increasingly rely on high availability (HA) technologies to maximize application uptime....
by Edith Puclla | Mar 6, 2025 | Cloud, Percona Software, PostgreSQL
If you are reading this blog post, chances are you’re either curious about Kubernetes Operators, or you’ve specifically decided to install the Percona Operator for PostgreSQL, which I am glad to know! Suppose your environment isn’t set up yet. In...
by Ibrar Ahmed | Mar 1, 2025 | Insight for DBAs, PostgreSQL
This blog post was originally published in January 2023 and was updated in March 2025. In PostgreSQL, the VACUUM command is a critical maintenance task essential to optimize database performance and reclaim wasted disk space. Using the PostgreSQL VACUUM command...
by David Quilty | Mar 1, 2025 | Insight for DBAs, Percona Software, PostgreSQL
This post was originally written in March 2023 and was updated in March 2025. You know that feeling when your database licensing renewal comes up and the number makes you wince? Or when you’re sitting in yet another meeting about why your current database...
by Jobin Augustine | Feb 27, 2025 | PostgreSQL
This post was originally published in March 2019 and was updated in February 2025. Planning a PostgreSQL upgrade but not sold on pg_upgrade? You’re not alone. If pg_upgrade feels too risky or limiting, pg_dump and pg_restore give you something better: full control....
