by Dmitriy Kostiuk | Apr 13, 2022 | Cloud, Percona Software, PostgreSQL
Tablespaces allow DBAs to store a database on multiple file systems within the same server and to control where (on which file systems) specific parts of the database are stored. You can think about it as if you were giving names to your disk mounts and then using...
by Robert Bernier | Apr 13, 2022 | Insight for DBAs, Open Source, PostgreSQL
Transaction ID Wraparound occurs when the VACUUM process cannot keep up with database activity and the PostgreSQL service is forced to shut down. In more technical parlance: Transaction ID Wraparound occurs when the semantics of Multi-Version Concurrency Control...
by Mike Benshoof | Mar 24, 2022 | Insight for DBAs, MySQL, PostgreSQL
DBAs can be set in their ways. Oftentimes, we start with a particular flavor and from that moment until the end of time, it will always be “the best”. In some cases, the debate is actually based on matching the use case to the proper tech (I’m looking at you SQL vs...
by Sergey Pronin | Mar 15, 2022 | Cloud, Open Source, Percona Software, PostgreSQL
Avoid vendor lock-in, provide a private Database-as-a-Service for internal teams, quickly deploy-test-destroy databases with CI/CD pipeline – these are some of the most common use cases for running databases on Kubernetes with operators. Percona Operator for...
by Jobin Augustine | Feb 25, 2022 | Insight for DBAs, PostgreSQL
I recently blogged about how Patroni Addresses the Problem of the Logical Replication Slot Failover in a PostgreSQL Cluster. In fact, nothing else was hurting a logical replication as much as this problem. Even while I am writing this post, I could see customers/users...
by David Gonzalez | Feb 8, 2022 | Insight for DBAs, Insight for Developers, PostgreSQL
The PostgreSQL RDBMS has shown rapid growth in terms of adoption and usability for a wide range of industries and projects. The same is true as for the new methodologies for application development and deployment, which currently focuses on making it easier for...
by Robert Bernier | Jan 31, 2022 | Database Trends, Insight for DBAs, Insight for Developers, PostgreSQL
Note: In the original version of this post, there were some issues missed. These have been addressed at the bottom of the post. I’d like to introduce to you a very cool feature introduced in PostgreSQL, the Pipeline Mode. So just what exactly is Pipeline Mode?...
by Jobin Augustine | Jan 25, 2022 | Insight for DBAs, PostgreSQL, Security
Recently, a few PostgreSQL users reported that they got connection failures after switching to PostgreSQL 14. “Why do I get the error FATAL: password authentication failed for a user in the new server?” has become one of the most intriguing questions. At...
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...
