by Jobin Augustine | Feb 13, 2020 | Insight for DBAs, PostgreSQL
As hardware and software evolve, the bottlenecks in a database system also shift. Many old problems might disappear and new types of problems pop-up. Old Limitations There were days when CPU and Memory was a limitation. More than a decade back, servers with 4 cores...
by David Quilty | Feb 7, 2020 | Insight for Developers, MongoDB, MySQL, PostgreSQL, Webinars
Most applications use databases, yet many fail to follow even the most basic best practices, resulting in poor performance, downtime, and security incidents. In this presentation, we will look into the foundational best practices you as a Developer should know about...
by Robert Bernier | Jan 21, 2020 | Insight for DBAs, Insight for Developers, PostgreSQL
Hello! My name is Robert and I am a PostgreSQL Consultant at Percona. I’ve been here since the summer of 2019 but things have been so busy that this is the first chance I’ve had to write. For my first blog, I’d like to write about … you. Or,...
by Jobin Augustine | Jan 17, 2020 | Insight for DBAs, PostgreSQL
Python 2 has officially completed its life as of Jan 1st, 2020 and the Python 2.x branch will not be maintained anymore. You might be seeing repeated notices of deprecation in log files and terminals like: Shell DEPRECATION: Python 2.7 will reach the end of its life...
by Jobin Augustine | Dec 3, 2019 | PostgreSQL
There is a less-talked-about improvement in PostgreSQL 12 which can greatly reduce the benign log entries. This patch is probably one of the smallest in PostgreSQL 12. The commit message says: Shell Don't log incomplete startup packet if it's empty This will stop...
by Ibrar Ahmed | Nov 20, 2019 | PostgreSQL
A global index, by very definition, is a single index on the parent table that maps to many underlying table partitions. The parent table itself does not have a single, unified underlying store so it must, therefore, retrieve the data satisfying index constraints from...
by Jobin Augustine | Nov 8, 2019 | Insight for DBAs, PostgreSQL
We discussed one of the traditional ways to configure HAProxy with PostgreSQL in our previous blog about HAProxy using Xinetd. There we briefly mentioned the limitation of the HAProxy’s built-in pgsql-check health check option. It lacks features to detect and...
by Jobin Augustine | Oct 31, 2019 | Insight for DBAs, PostgreSQL
Recently we published a blog about a very simple application failover using libpq features which could be the simplest of all automatic application connection routing. In this blog post, we are discussing how a proxy server using HAProxy can be used for connection...
by Avinash Vallarapu | Oct 29, 2019 | Percona Software, PostgreSQL
PostgreSQL is a widely-used Open Source database and has been the DBMS of the year for the past 2 years in DB-Engine rankings. As such, there is always a need for reliable and robust monitoring solutions. While there are some commercial monitoring tools, there is an...
by Avinash Vallarapu | Oct 23, 2019 | PostgreSQL
When you build replication in PostgreSQL using Streaming replication, you cannot perform writes to a standby node; only reads. This way, you could offload reads or reporting queries to standby servers and send writes to master. Additionally, starting from PostgreSQL...
by Avinash Vallarapu | Oct 11, 2019 | PostgreSQL
PostgreSQL 12 can be considered revolutionary considering the performance boost we observe with partitioning enhancements, planner improvements, several SQL features, Indexing improvements, etc. You may see some of such features discussed in future blog posts. But,...
by Dmitriy Kostiuk | Oct 9, 2019 | Monitoring, Percona Software
Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring your database performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL®,...
by Dmitriy Kostiuk | Sep 19, 2019 | Monitoring, Percona Software
Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL®, MongoDB®, and PostgreSQL® performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis...
by Dmitriy Kostiuk | Sep 19, 2019 | Monitoring, Percona Software
We are pleased to announce the General Availability of PMM2, our latest software release! Created specifically to support open source software users, Percona Monitoring and Management (PMM) is a leading, free, open-source platform that allows you to actively manage...
by Rick Golba | Sep 17, 2019 | Percona Software, PostgreSQL
Percona Distribution for PostgreSQL – the best and most critical enterprise-level components from the open-source community, brought together in one single source. Percona is pleased to announce the general availability of our Percona Distribution for PostgreSQL...
by Dmitriy Kostiuk | Sep 9, 2019 | Monitoring, Percona Software
We are pleased to announce our 7th Beta release of PMM 2! Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance. This release includes the following improvements: Query...
by Borys Belinsky | Aug 19, 2019 | Percona Software, PostgreSQL
Percona is excited to announce the beta release of Percona Distribution for PostgreSQL 11 on August 19, 2019. This release signifies a change in Percona’s software release process. In order to provide a full-featured and holistic solution, we are introducing a product...
by Jobin Augustine | Aug 15, 2019 | Benchmarks, PostgreSQL
by Ibrar Ahmed | Aug 2, 2019 | PostgreSQL
In a Linux world, whenever your database server crashes or gets terminated, you need to find its cause. There can be several reasons for this. It can be SIGSEGV, which is a crash due to some bug in the backend server, but this is the least likely reason. The most...
by Jobin Augustine | Jul 31, 2019 | PostgreSQL
One of the great features of PostgreSQL is its extendability. My colleague and senior PostgreSQL developer Ibar has blogged about developing an extension with much broader capabilities including callback functionality. But in this blog post, I am trying to address a...
