Featured
MySQL 5.7
End of Life
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
May 7, 2024
Speed Up Repetitive PostgreSQL Statements With \gexec
Last week, we were assisting a client who needed to resolve an issue related to partitioned tables. Often, a table [...]
April 30, 2024
LDAP Authentication in PgBouncer Through PAM
There are many cases where external connection poolers like pgBouncer become unavoidable despite the costs and complexities associated with them. [...]
April 26, 2024
Trying out the PostgreSQL pg_tde Tech Preview Release
The tech preview version of the pg_tde extension for PostgreSQL 16 was released on March 28th, with many improvements compared [...]
April 22, 2024
PostgreSQL Database Security Best Practices
When data is everything, the sophistication of cybersecurity threats casts a shadow over the world of data security, including for [...]
April 18, 2024
How to Improve Database Performance: The Ultimate Guide
Welcome to the ultimate guide on how to boost your database performance! We’ve designed it to help you understand and [...]
April 17, 2024
Switch PostgreSQL Environments Across AWS, GCP, and k3d Using Kubernetes Contexts
This article explains how to install the Percona Distribution for PostgreSQL on Kubernetes using “context”. We will show you how [...]
April 12, 2024
Partially Rolling Back a Transaction in MySQL or PostgreSQL
This short write-up focuses on a different transaction control behavior of databases. Though this is not unusual, I decided to [...]
April 11, 2024
JSON_TABLE() Will Be in PostgreSQL 17
JSON_TABLE() will be in PostgreSQL 17! It almost made it two years ago but was yanked away at the last [...]
April 9, 2024
Protect Your PostgreSQL Database with pg_tde: Safe and Secure
Tech Preview release of pg_tde now available As organizations collect, store, and analyze vast amounts of data, ensuring its confidentiality [...]
April 5, 2024
Best Practices for PostgreSQL Migration
PostgreSQL’s reputation as a powerful, open source database management system has been steadily rising, making it a top choice for [...]
April 3, 2024
Foreign Data Wrappers in PostgreSQL Databases (postgres_fdw & dblink)
A Foreign Data Wrapper (FDW) is a feature in database management systems that can communicate with an external data source [...]
April 2, 2024
PostgreSQL for MySQL DBAs Second Edition Is Now Available
Many years ago, when I was the Certification Manager for MySQL AB, I would be in contact with hiring managers [...]
April 2, 2024
Five Reasons Why WAL Segments Accumulate in the pg_wal Directory in PostgreSQL
One of the most frequent concerns we see in the Percona support team is: Why is my pg_wal growing? / [...]
April 1, 2024
Percona pg_tde Project Keyring Options
Percona’s pg_tde project brings a long-needed ability to encrypt data to PostgreSQL transparently. We are actively asking you to test [...]
April 1, 2024
PostgreSQL Indexes Can Hurt Performance: Exploring the Negative Effects and the Costs Involved
This blog was originally published in April 2023 and was updated in April 2024. Indexes are generally considered to be [...]
April 1, 2024
PostgreSQL Partitioning Using Traditional Methods
This blog was originally published in July 2023 and was updated in April 2024. Partitioning is the concept of splitting [...]
April 1, 2024
PostgreSQL: Pgpool-II Use Cases and Benefits
This blog was published in April of 2023 and updated in April 2024. PostgreSQL is a popular open source relational [...]
April 1, 2024
How to Set and Tune Autovacuum Settings in PostgreSQL to Avoid Performance Issues
This blog was originally published in June 2022 and was updated in April 2024. PostgreSQL’s built-in autovacuum – the housekeeper [...]
March 28, 2024
Percona’s PostgreSQL pg_tde Extension: March Update
Transparent Data Encryption is one ‘missing item’ in comparing PostgreSQL to commercial databases. Percona’s pg_tde project will correct this shortcoming. [...]
March 27, 2024
Enhancing PostgreSQL Insights with Percona Monitoring and Management: A Closer Look at Recent Updates
Database monitoring tools play a crucial role in ensuring the smooth operation and performance optimization of database systems, and Percona [...]