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 Mario García | Mar 24, 2025 | Insight for DBAs, PostgreSQL
This post was originally published in March 2023 and was updated in March 2025. If you’re using PostgreSQL in the cloud, there’s a good chance you’re spending more than you need in order to get the results required for your business. Effectively managing PostgreSQL...
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 Avinash Vallarapu | Mar 1, 2025 | Insight for DBAs, PostgreSQL
This blog was originally written in September 2018 and was updated in March 2025. In this post, we cover the methods used to achieve an enterprise-grade PostgreSQL backup strategy. We’ll explore options like pg_basebackup and WAL archiving to enable PostgreSQL...
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....
by Ege Gunes | Feb 7, 2025 | Cloud, Percona Software, PostgreSQL
The upcoming Percona Operator for PostgreSQL v2.6.0 release introduces support for PostgreSQL 17, which opens exciting possibilities for data security. Since pg_tde comes pre-installed in Percona’s official PostgreSQL 17 images, this release presents an...
by David Quilty | Jan 22, 2025 | PostgreSQL, Security
Data security threats are becoming increasingly sophisticated, creating real challenges for organizations using PostgreSQL databases. While PostgreSQL is known for its reliability and feature-rich platform, a security breach can lead to serious consequences—damaged...
by Jobin Augustine | Jan 14, 2025 | Insight for DBAs, Insight for Developers, PostgreSQL
PostgreSQL is one of the most powerful database systems in the world. I have always been passionate about its great power, especially its modern SQL language features. However, that doesn’t mean everything is great. There are areas where it hurts. Novice users unaware...
by Valeria Bogatyreva | Jan 13, 2025 | Cloud, PostgreSQL
Originally published on The New Stack. Cloud-related regulatory, security and financial issues prompt many to weigh the benefits of building GenAI on on-premises and hybrid databases. Generative AI (GenAI) has already shown its potential to reshape industries,...
by David Quilty | Jan 11, 2025 | Insight for DBAs, Monitoring, PostgreSQL
Maybe queries that used to finish in milliseconds are now taking seconds. Perhaps your application is timing out during peak hours, or worse, users are complaining about slow page loads. By the time you notice something’s wrong, you’re already in crisis....
by Jan Wieremjewicz | Jan 9, 2025 | Open Source, PostgreSQL, Security
If you’re managing a PostgreSQL database and handling sensitive data or PII, the answer is simple: You need data-at-rest encryption. This isn’t just a “nice-to-have” feature—it’s often a legal or regulatory requirement. Compliance auditors, security...
by Anil Joshi | Jan 2, 2025 | Insight for DBAs, PostgreSQL
As we know, Patroni is a well-established standard for an HA framework for PostgreSQL clusters. From time to time, we need to perform maintenance tasks like upgrading the topology or making changes to the existing setup. Here, we will discuss mainly how we can replace...
by Robert Bernier | Dec 9, 2024 | Insight for DBAs, PostgreSQL
First things first, a couple of definitions to clear up: ETL: Extract, Transform, Load. Transforms data before loading it into the target system extract raw data from various sources use a secondary processing server to transform that data load that data into a target...
by Fernando Laudares Camargos | Nov 19, 2024 | Cloud, Monitoring, Percona Software, PostgreSQL
