Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
June 30, 2025
The PG_TDE Extension Is Now Ready for Production
Lately, it feels like every time I go to a technical conference, someone is talking about how great PostgreSQL is. [...]
June 27, 2025
Managing PostgreSQL on Kubernetes with Percona Everest’s REST API
I’ve been working with Kubernetes and databases for the past few months, and I’m enjoying learning and exploring more about [...]
June 16, 2025
Integrating Repmgr with Barman: Managing Backups During Switchovers
Repmgr is an open source tool suite for managing replication and failover in a cluster of PostgreSQL servers. It enhances [...]
June 16, 2025
Using MERGE To Make Your PostgreSQL More Powerful
This blog was first authored in 2022. We’ve updated it in 2025 for clarity and relevance, reflecting current practices while [...]
June 11, 2025
Storage Strategies for PostgreSQL on Kubernetes
This post was originally published in 2023, and we’ve updated it in 2025 for clarity and relevance, reflecting current practices [...]
June 10, 2025
A Practical Guide to PostgreSQL Indexes
This blog was first authored in 2024 and we’ve updated it in 2025 for clarity and relevance, reflecting current practices [...]
June 9, 2025
How to Perform a Disaster Recovery Switchover with Patroni for PostgreSQL
Patroni is a Python-based template for managing high availability PostgreSQL clusters. Originally a fork of the Governor project by Compose, Patroni [...]
June 6, 2025
PgBouncer for PostgreSQL: How Connection Pooling Solves Enterprise Slowdowns
If your database is getting slower, your users don’t care why. They just want it to work. Meanwhile, you’re stuck [...]
May 27, 2025
Beyond Guesswork: Enterprise-Grade PostgreSQL Tuning with pg_stat_statements
Something’s slowing your database down, and everyone feels it. Dashboards drag. Reports run late. Engineers start rebooting services just to [...]
May 14, 2025
Configuring PgBouncer auth_type with Trust and HBA: Examples and Known Issues
PgBouncer is a lightweight external connection pooler that can be introduced between an application and a PostgreSQL database. It manages [...]
May 9, 2025
Patroni: The Key PostgreSQL Component for Enterprise High Availability
You don’t have time for database downtime. Whether you’re managing a high-traffic application, supporting business-critical transactions, or ensuring real-time analytics [...]
April 30, 2025
Useful PostgreSQL Index Maintenance Queries to Improve Performance
This blog was first authored in 2020. We’ve updated it in 2025 for clarity and relevance, reflecting current practices while [...]
April 30, 2025
Benchmarking PostgreSQL: The Hidden Cost of Over-Indexing
Indexing is one of PostgreSQL’s most effective tools for improving query performance, but like any powerful tool, it can cause [...]
April 25, 2025
pgvector: The Critical PostgreSQL Component for Your Enterprise AI Strategy
You’re likely racing to enhance your applications with more intelligent, data-driven capabilities, whether through AI-powered models (which have moved into [...]
April 25, 2025
How to Upgrade PostgreSQL Extensions (Without Breaking Anything)
This blog was first authored by Ibrar Ahmed in 2023. We’ve updated it in 2025 for clarity and relevance, reflecting [...]
April 18, 2025
Run PostgreSQL on Kubernetes: A Practical Guide with Benchmarks and Best Practices
Remember when running databases in Kubernetes felt like a gamble? When unpredictable storage performance and complex state management made stability [...]
April 15, 2025
Avoiding PostgreSQL Upgrade Errors: A Practical Guide
This post was originally published in January 2024 and was updated in April 2025. Thinking about a PostgreSQL upgrade? Here’s [...]
April 5, 2025
Troubleshooting 10 of the Most Common PostgreSQL Errors
This blog was first authored by Ibrar Ahmed in 2020. We’ve updated it in 2025 for clarity and relevance, reflecting [...]
April 5, 2025
The PostgreSQL Migration Playbook: What to Plan, Avoid, and Expect
Thinking about moving to PostgreSQL? You’re not the only one. Maybe it’s the licensing fees your current database keeps hiking [...]
April 5, 2025
Why PostgreSQL NULL Values Break Your Queries (And How to Fix Them)
This blog was first authored by Ibrar Ahmed in 2020. We’ve updated it in 2025 for clarity and relevance, reflecting [...]