by Jobin Augustine | Jan 13, 2022 | Insight for DBAs, PostgreSQL
Failover of the logical replication slot has always been the pain point while using the logical replication in PostgreSQL. This lack of feature undermined the use of logical replication and acted as one of the biggest deterrents. The stake and impact were so high that...
by Fernando Laudares Camargos | Jan 11, 2022 | Cloud, Percona Software, PostgreSQL
A customer recently asked if our Percona Operator for PostgreSQL supports the deployment of a standby cluster, which they need as part of their Disaster Recovery (DR) strategy. The answer is yes – as long as you are making use of an object storage system for...
by Fernando Laudares Camargos | Dec 20, 2021 | Monitoring, Percona Software, PostgreSQL
The recent release of Percona Monitoring and Management 2.25.0 (PMM) includes a fix for bug PMM-6937: before that, PMM expected all monitoring connections to PostgreSQL servers to be made using the default postgres database. This worked well for most deployments,...
by Sergey Pronin | Dec 8, 2021 | Cloud, Insight for Developers, Percona Software, PostgreSQL
Percona in 2021 is heavily invested in making the PostgreSQL ecosystem better and contributing to it from different angles: We have created pg_stat_monitor – query performance monitoring tool for PostgreSQL Percona Distribution for PostgreSQL Operator was...
by Ibrar Ahmed | Nov 29, 2021 | Insight for DBAs, PostgreSQL
PostgreSQL-14 was released in September 2021, and it contained many performance improvements and feature enhancements, including some features from a monitoring perspective. As we know, monitoring is the key element of any database management system, and PostgreSQL...
by Robert Bernier | Nov 23, 2021 | Insight for DBAs, PostgreSQL
My last blog introduced the issues one can face when upgrading PostGIS and PostgreSQL at the same time. The purpose of this blog is to walk through the steps with an example. For our purposes, we will confine ourselves to working with the community versions of 9.6 and...
by Charly Batista | Nov 18, 2021 | Insight for DBAs, Insight for Developers, PostgreSQL
Welcome to a weekly blog where I get to answer (like, really answer) some of the questions I’ve seen in the webinars I’ve presented lately. If you missed the latest one, PostgreSQL Performance Tuning Secrets, it might be helpful to give some of it a listen before or...
by Robert Bernier | Nov 10, 2021 | Insight for DBAs, PostgreSQL
PostGIS is arguably the best GIS implementation in the world. There may be other database technologies with GIS but the value proposition of quality, performance, and sophistication, and, of course, cost, is nowhere near what PostgreSQL offers. So let me set the stage...
by Matt Yonkovit | Oct 14, 2021 | Monitoring, MySQL, Percona Software, PostgreSQL
A few weeks ago we did a live stream talking about Percona Monitoring and Management (PMM) and showcased some of the fun things we were doing at the OSS Summit. During the live stream, we tried to enable some custom queries to track the number of comments being added...
by Jobin Augustine | Oct 12, 2021 | Insight for DBAs, Insight for Developers, PostgreSQL
Often users come to us with incidents of database crashes due to OOM Killer. The Out Of Memory killer terminates PostgreSQL processes and remains the top reason for most of the PostgreSQL database crashes reported to us. There could be multiple reasons why a host...
by Matt Yonkovit | Oct 7, 2021 | Insight for DBAs, Insight for Developers, PostgreSQL
Don’t miss the great overview of PostgreSQL 14 that Umair Shahid recently put together, PostgreSQL 14 – Performance, Security, Usability, and Observability! Range data types have been in Postgresql for some time now, however, as of PostgreSQL 14, we have seen...
by Matt Yonkovit | Oct 5, 2021 | Insight for DBAs, PostgreSQL
As previously mentioned here on the blog, PostgreSQL 14 was just released. Need a primer? Umair Shahid recently put together a great overview, PostgreSQL 14 – Performance, Security, Usability, and Observability. I recently did a deep-dive into using JSON from within...
by Daniil Bazhenov | Oct 1, 2021 | MongoDB, MySQL, Percona Events, PostgreSQL
Percona serves several communities including MySQL, PostgreSQL, and MongoDB. The Percona Community Team is committed to promoting content and technical advice on open source database technologies and needs. Hence, we organize monthly MeetUps as a series of regular...
by Umair Shahid | Sep 30, 2021 | Database Trends, Percona Software, PostgreSQL
Today saw the launch of PostgreSQL14. For me, the important area to focus on is what the community has done to improve performance for heavy transactional workloads and additional support for distributed data. The amount of data that enterprises have to process...
by Umair Shahid | Sep 27, 2021 | Database Trends, Insight for DBAs, Percona Software, PostgreSQL
The future of technology adoption belongs to developers. The future of application deployment belongs in the cloud. The future of databases belongs to open source. That’s essentially the summary of Percona’s innovation strategy and that’s the reason I decided to join...
by Matt Yonkovit | Sep 8, 2021 | Insight for DBAs, PostgreSQL
by Matt Yonkovit | Sep 3, 2021 | Insight for DBAs, PostgreSQL
Continuing our series on storing JSON directly within your database, we are now looking at the JSON functionality built into PostgreSQL. You can see the first two posts in this series exploring MySQL’s JSON functionality with Storing JSON in Your Databases: Tips and...
by Sergey Kuzmichev | Aug 24, 2021 | Insight for DBAs, Monitoring, Percona Software, PostgreSQL
At the recent Percona Live, Agustín Gallego and I did a presentation “Optimizing and Troubleshooting PostgreSQL with PMM”. While preparing for this talk, I’ve ported some of the older PostgreSQL custom dashboards that we published over the years over at...
by Ibrar Ahmed | Aug 23, 2021 | Insight for DBAs, PostgreSQL, Security
Security is everybody’s concern when talking about data and information, and therefore it becomes the main foundation of every database. Security means protecting your data from unauthorized access. That means only authorized users can log in to a system called...
by Charly Batista | Aug 10, 2021 | Insight for DBAs, Insight for Developers, PostgreSQL
