Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
November 29, 2021
PostgreSQL 14 Database Monitoring and Logging Enhancements
PostgreSQL-14 was released in September 2021, and it contained many performance improvements and feature enhancements, including some features from a [...]
November 23, 2021
Upgrading PostGIS: A Proof Of Concept
My last blog introduced the issues one can face when upgrading PostGIS and PostgreSQL at the same time. The purpose [...]
November 18, 2021
Should I Create an Index on Foreign Keys in PostgreSQL?
Welcome to a weekly blog where I get to answer (like, really answer) some of the questions I’ve seen in [...]
November 10, 2021
Issues Upgrading PostGIS and PostgreSQL
PostGIS is arguably the best GIS implementation in the world. There may be other database technologies with GIS but the [...]
October 14, 2021
Custom Percona Monitoring and Management Metrics in MySQL and PostgreSQL
A few weeks ago we did a live stream talking about Percona Monitoring and Management (PMM) and showcased some of [...]
October 12, 2021
Why Linux HugePages are Super Important for Database Servers: A Case with PostgreSQL
Often users come to us with incidents of database crashes due to OOM Killer. The Out Of Memory killer terminates [...]
October 7, 2021
Using the Range and the New Multirange Data Type in PostgreSQL 14
Don’t miss the great overview of PostgreSQL 14 that Umair Shahid recently put together, PostgreSQL 14 – Performance, Security, Usability, [...]
October 5, 2021
Using New JSON Syntax in PostgreSQL 14 – Update
As previously mentioned here on the blog, PostgreSQL 14 was just released. Need a primer? Umair Shahid recently put together [...]
October 1, 2021
Join Community MeetUps for MySQL, PostgreSQL, MongoDB, or PMM
Percona serves several communities including MySQL, PostgreSQL, and MongoDB. The Percona Community Team is committed to promoting content and technical [...]
September 30, 2021
PostgreSQL 14 – Performance, Security, Usability, and Observability
Today saw the launch of PostgreSQL14. For me, the important area to focus on is what the community has done [...]
September 27, 2021
Percona and PostgreSQL: Better Together
The future of technology adoption belongs to developers. The future of application deployment belongs in the cloud. The future of [...]
September 8, 2021
Storing and Using JSON Within PostgreSQL Part Two
We explored the basic functionality of JSON within PostgreSQL in Part One of this series. Now we will look a [...]
September 3, 2021
Storing and Using JSON Within PostgreSQL Part One
Continuing our series on storing JSON directly within your database, we are now looking at the JSON functionality built into [...]
August 24, 2021
PostgreSQL Custom Dashboards Ported to Percona Monitoring and Management 2
At the recent Percona Live, Agustín Gallego and I did a presentation “Optimizing and Troubleshooting PostgreSQL with PMM“. While preparing [...]
August 23, 2021
PostgreSQL Database Security: OS – Authentication
Security is everybody’s concern when talking about data and information, and therefore it becomes the main foundation of every database. [...]
August 13, 2021
Migrating PostgreSQL to Kubernetes
More and more companies are adopting Kubernetes. For some it is about being cutting-edge, for some, it is a well-defined [...]
August 10, 2021
PostgreSQL PL/Java – A How-To, Part 2: How to Manipulate and Return Tuples
We discussed how to install and create a simple class in the first part of this series where we ran [...]
August 10, 2021
Impact of Network and Cursor on Query Performance of PostgreSQL
Many times, we see PostgreSQL users getting confused about the query/statement duration reported in PostgreSQL logs. Other PostgreSQL tools like [...]
July 30, 2021
Improve PostgreSQL Query Performance Insights with pg_stat_monitor
Understanding query performance patterns is essentially the foundation for query performance tuning. It, in many ways, dictates how a database [...]
July 29, 2021
PostgreSQL PL/Java – A How-To, Part 1
We’ve recently received some questions regarding PL/Java and I found it hard to get clear instructions searching on the internet. [...]