Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
August 16, 2023
Streamline the SQL Code: Guide to pgFormatter
In database management, well-formatted SQL code is easier to read and a vital aspect of maintaining clean, efficient, and error-free [...]
July 20, 2023
How To Measure the Network Impact on PostgreSQL Performance
It is very common to see many infrastructure layers standing between a PostgreSQL database and the Application server. The most [...]
July 19, 2023
Deploy PostgreSQL on Kubernetes Using GitOps and ArgoCD
In the world of modern DevOps, deployment automation tools have become essential for streamlining processes and ensuring consistent, reliable deployments. [...]
July 7, 2023
Online Data Type Change in PostgreSQL
Changing the data type on a column in a big table is almost always a pain. It can lock out [...]
July 6, 2023
One Index, Three Different PostgreSQL Scan Types: Bitmap, Index, and Index Only
Performance is one of the essential aspects of a database management system. Very little can be more annoying and frustrating [...]
June 30, 2023
Announcing the General Availability of Percona Operator for PostgreSQL Version 2
Percona, a leading provider of open-source database software and services, announced the general availability of Percona Operator for PostgreSQL version [...]
June 29, 2023
Find the WAL Count Between Two Segments in PostgreSQL
The PostgreSQL Write-Ahead Log (WAL) is a recording location within the Postgres cluster, capturing all modifications made to the cluster’s [...]
June 26, 2023
What To Do When a Data File in PostgreSQL Goes Missing
We have faced different levels of corruption related to databases in PostgreSQL. Our colleague has written multiple blogs on the [...]
June 20, 2023
Deploy Django on Kubernetes With Percona Operator for PostgreSQL
Developers need an efficient, reliable way to run their Django applications with a robust PostgreSQL. Percona Operator for PostgreSQL offers [...]
June 15, 2023
Using PostGIS To Enable Better Performance in PostgreSQL
This post was originally published in 2020 and has been updated in 2023. Mastering Geographical Information Systems, better known simply [...]
June 14, 2023
Should PostgreSQL Become Multi-Threaded?
A few days ago, Heikki Linnakangas posted a message in the PostgreSQL mailing list titled “Let’s make PostgreSQL multi-threaded.” This [...]
June 12, 2023
Ready-to-Use High Availability Architectures for MySQL and PostgreSQL
When it comes to access to their applications, users demand instant, reliable, and secure interactions — and that means databases [...]
June 9, 2023
Monitoring a PostgreSQL Patroni Cluster
Percona Monitoring and Management (PMM) boasts many functionalities that support its extension, be it by using Custom Queries, Custom Scripts, [...]
June 7, 2023
Unleashing the Power of PostgreSQL Event-Based Triggers
PostgreSQL provides a powerful mechanism for implementing event-driven actions using triggers. Triggers on Data Definition Language (DDL) events are a [...]
June 5, 2023
Configuring PgBouncer for Multi-Port Access
From time to time, situations occur where unusual circumstances dictate out-of-the-box thinking. For example, suppose you have a system where [...]
May 8, 2023
How to Start PostgreSQL Logical Replication with pg_dump
In simpler terms, logical replication in PostgreSQL is a way to copy data from one database to another in a [...]
April 20, 2023
Using Encryption-at-Rest for PostgreSQL in Kubernetes
Data-at-rest encryption is essential for compliance with regulations that require the protection of sensitive data. Encryption can help organizations comply [...]
April 13, 2023
PostgreSQL Replication Lag: Everything You Need to Know About Replication Lag in PostgreSQL
This blog was originally published in April 2023 and was updated in April 2024. PostgreSQL is a popular open source [...]
April 6, 2023
Turbocharging Percona Monitoring and Management With Loki’s Log-shipping Functionality
In this blog post, we’ll check how to integrate Percona Monitoring and Management (PMM) with Loki to be able to [...]
April 3, 2023
PostgreSQL Upgrade: Tricks With OID Columns and Extensions
We all know that PostgreSQL 10 has reached end of support, so if you’re still running it, the time to [...]