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....
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
by Kai Wagner | Nov 18, 2024 | Open Source, Percona Software, PostgreSQL
PostgreSQL 12 reached its End of Life (EOL) on November 14, 2024. For more information, see the official PostgreSQL versioning policy page. This milestone marks the end of regular updates, bug fixes, and critical security patches for version 12. If you are still...
by Jan Wieremjewicz | Nov 6, 2024 | Cloud, Database Trends, Insight for DBAs, PostgreSQL
TL;DR Kubernetes was built for stateless apps, but as more stateful applications (like databases) run on it, operators include quite heavy implementations to Kubernetes workload management API (such as StatefulSets) deficits. While creating custom methods allows...
by Sergey Pronin | Nov 4, 2024 | Cloud, Percona Software, PostgreSQL
I wrote a blog post in the past about a generic approach on how to expose databases in Kubernetes with Ingress controllers. Today, we will dive deeper into PostgreSQL with ingress and also review two different ways that can be taken to expose the TCP service. The goal...
by Peter Zaitsev | Nov 1, 2024 | MySQL, Open Source, PostgreSQL
When I talk to old-timers in the MySQL community, I often hear this question: “How come MySQL is so awesome and still more popular than PostgreSQL (according to DB-Engines methodology at least), but it is losing ground while PostgreSQL’s growth in...
by Jan Wieremjewicz | Aug 15, 2024 | Open Source, Percona Software, PostgreSQL
When using a tool for a while, one often becomes patriotic towards it. With your investment, such as your work, you’re building up experience and starting to care more about the tool you use. How good it is, how it’s perceived by others. It’s an interesting process....
by Lalit Choudhary | Aug 13, 2024 | Insight for DBAs, PostgreSQL
Character collations determine the sort order and classification of characters. When creating a database with initdb, PostgreSQL normally sets the collation based on the operating system’s locale settings, but other special collations, such as “C,”...
