Percona Resources

Software
Downloads

All of Percona’s open source software products, in one place, to download as much or as little as you need.

Valkey Contribution

Product Documentation

Why Percona for MongoDB?

Why Percona for PostgreSQL?

Percona Blog

Percona Blog

Our popular knowledge center for all Percona products and all related topics.

Community

Percona Community Hub

A place to stay in touch with the open-source community

Events

Percona Events Hub

See all of Percona’s upcoming events and view materials like webinars and forums from past events

About

About Percona

Percona is an open source database software, support, and services company that helps make databases and applications run better.

Percona in the News

See Percona’s recent news coverage, press releases and industry recognition for our open source software and support.

Our Customers

Our Partners

Careers

Contact Us

David Stokes
David Stokes is a Technology Evangelist for Percona Corporation, is the author of MySQL & JSON - A Practical Programming Guide, and resides in Texas.

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 honoring their original perspective. PostgreSQL 15 introduced the MERGE command, a feature that has a big impact on how you can manage data updates. With MERGE, you can combine inserts, updates, and deletes into a […]

MySQL 9.0 Includes a New Option for Explaining Queries

MySQL 9.0 is an Innovation Release, but as you may have read in my Quick Peek, I found little innovation. However, one new item caught my eye, and it could be a way to track query performance. MySQL 9.0 EXPLAIN enhancement Here is the syntax that will be referenced in the post. {EXPLAIN | DESCRIBE […]

MySQL 9.0 Community Edition: A Quick Peek

MySQL 9.0 was released on July 1, 2024. This is an ‘Innovation’ release, which means it provides access to the latest features and improvements in MySQL technologies. Innovation releases are the opposite of the Long Term Support (LTS) releases, where stability is the top priority, and only needed security and other fixes are available. This […]

Are Your Backups Able to Pass the Unisuper Test?

You may have heard about Unisuper’s problem last week; see here. The $135 billion dollar company’s data was wiped off its cloud, and everything disappeared—zip, zero, nada. Everything they relied upon was gone. Their Google Cloud experience has been labeled an “unprecedented occurrence.” Wouldn’t you like to hear the audio recording of the help desk […]

MySQL 8.4 First Peek

MySQL 8.4 has now been officially released, and this is a quick review of what is in the release notes. This is momentous as it is designated a Long-Term Support (LTS) release. Various 8.0 releases introduced material changes that impacted speed and stability, causing hair-pulling and swearing among those affected. Please note this is a […]

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 minute. We will get it shortly when PostgreSQL 17 is officially released this year! Please see this. Why is this important? JSON has become the data interchange format of choice for most developers. JSON had […]

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 looking for talent. One frustrated individual informed me that while it was hard to find a qualified MySQL DBA, it was impossible to find a qualified PostgreSQL DBA. Years later, that same sentiment is still […]

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 this code to help build a better project. So please test pg_tde! As you have probably read in earlier blogs on pg_tde, it depends on a keyring. Two keys Encrypting the data requires two types […]

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. Progress is ongoing, and Percona would love your feedback, so please download and test. Documentation The pg_tde documentation is here. You will find many options for obtaining pg_tde – Docker images, RPM, DEB, and source […]

Quick Peek: MySQL 8.0.36 and 8.3

Oracle recently released MySQL 8.0.36 and MySQL 8.3, and this is a perusal of the release notes to determine what is new, what is in the seventy-three bugs fixed, and what has changed in the three months since the last releases. Comments in italics are my own and do not reflect the view of anyone […]

Book Review: PostgreSQL 14 Internals by Egor Rogov

The book PostgreSQL 14 Internals has been available in PDF format for quite a while, but recently, the ability to order a printed copy became available (https://postgrespro.com/community/books/internals). This 548-page tome from PostgresPro covers the spectrum from data organization to details on the many available indexing options.  This book has five major sections on MVCC and […]

Quick Peek: MySQL 8.2 and 8.0.35

Oracle recently made their quarterly releases with MySQL 8.0.35 and MySQL 8.2. This blog post is a quick look at the release notes to see what these new versions bring to the community. You’ll want to keep an eye on the deprecations in particular because some long-accepted behavior, including wildcards, will change eventually. We get […]