Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
September 16, 2025
What is Percona’s Transparent Data Encryption Extension for PostgreSQL (pg_tde)?
If you’re running PostgreSQL in a regulated industry, you know the frustration: your compliance auditor demands data-at-rest encryption, but PostgreSQL [...]
September 8, 2025
Swimming with Sharks: Analyzing Encrypted Database Traffic Using Wireshark
Percona has a great set of tools known as the Percona Toolkit, one of which is pt-upgrade. The idea behind [...]
August 20, 2025
Deep Diving the Citus Distribution Models Along with Shard Balancing/Read Scaling
In my previous blog post, Integrating Citus with Patroni: Sharding and High Availability Together, I explored how to integrate Citus [...]
August 13, 2025
Webinar Q&A: No More Workarounds: Open Source PostgreSQL TDE Is Here
I would like to thank everyone who attended my webinar, “No More Workarounds: Open Source PostgreSQL TDE Is Here,” on [...]
August 5, 2025
Planning Ahead for PostgreSQL 18: What Matters for Your Organization
PostgreSQL 18 is on the way, bringing a set of improvements that many organizations will find useful. It’s not a [...]
August 4, 2025
Integrating Citus with Patroni: Sharding and High Availability Together
Citus is a PostgreSQL extension developed with the intention of sharding and distributing the data across multiple machines. It offers [...]
August 2, 2025
Enhancing PostgreSQL Security: How to Encrypt the pgBackRest Repository
This post was originally written in 2023 and was updated in 2025. Encryption protects sensitive information by converting it into [...]
August 2, 2025
PostgreSQL Database Security: External Server-Based Authentication
This post was originally written in 2023 and was updated in 2025. Protecting sensitive information in PostgreSQL starts with strong [...]
July 30, 2025
A Practical Guide to PostgreSQL Replication with Both Asynchronous and Synchronous Standbys
PostgreSQL streaming replication allows a standby server to continuously replicate data from a primary server. It operates by streaming Write-Ahead [...]
July 29, 2025
Disaster Recovery for PostgreSQL on Kubernetes
This post was originally published in 2023, and we’ve updated it in 2025 for clarity and relevance. Downtime is more [...]
July 23, 2025
The Quirks of Index Maintenance in Open Source Databases
Index maintenance can be a real challenge for anyone managing databases, and what makes it even trickier is that open [...]
July 17, 2025
How Can AI Talk to My (PostgreSQL) Database?
I admittedly have some work to do to catch up with the AI “trend”. It’s been around (as in, easily [...]
July 13, 2025
Run PostgreSQL in Kubernetes: Solutions, Pros and Cons
This post was originally published in 2022, and we’ve updated it in 2025 for clarity and relevance. PostgreSQL was initially [...]
July 11, 2025
PostgreSQL Backup and Restore 101: For Non-Postgres DBAs
This post was originally published in 2022, and we’ve updated it in 2025 for clarity and relevance, reflecting current practices [...]
July 10, 2025
Working with Geospatial Data? PostGIS Makes PostgreSQL Enterprise-Ready
Do you find yourself struggling with geospatial data in your database? You know the feeling: you need quick answers about [...]
July 8, 2025
Transparent Data Encryption: The Best Way to Secure Your Data in PostgreSQL
Welcome to the open source implementation of PostgreSQL Transparent Data Encryption! This question was posed on the PostgreSQL forum, and [...]
July 5, 2025
Enabling and Enforcing SSL/TLS for PostgreSQL Connections
This post was originally published in July 2022, and we’ve updated it in 2025 for clarity and relevance, reflecting current [...]
July 3, 2025
A Tale of Two Databases: How PostgreSQL and MySQL Handle Torn Pages
Welcome to this first installment of the blog series, which explores how PostgreSQL and MySQL deal with different aspects of [...]
July 2, 2025
Testing ReadySet as a Query Cacher for PostgreSQL (Plus ProxySQL and HAproxy) Part 2: Test Results
In the first post of this series (Testing ReadySet as a Query Cacher for PostgreSQL (Plus ProxySQL and HAproxy) Part [...]
July 1, 2025
Testing ReadySet as a Query Cacher for PostgreSQL (Plus ProxySQL and HAproxy) Part 1: How-To
A couple of weeks ago, I attended a PGDay event in Blumenau, a city not far away from where I [...]