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...
by Avinash Vallarapu | Jul 30, 2019 | PostgreSQL
There is always a need for profiling tools in databases for admins or developers. While it is easy to understand the point where an SQL is spending more time using EXPLAIN or EXPLAIN ANALYZE in PostgreSQL, the same would not work for functions. Recently, Jobin has...
by Ibrar Ahmed | Jul 30, 2019 | PostgreSQL
PostgreSQL is one of the finest object-relational databases, and its architecture is process-based instead of thread-based. While almost all the current database systems utilize threads for parallelism, PostgreSQL’s process-based architecture was implemented...
by Avinash Vallarapu | Jul 22, 2019 | PostgreSQL
In my previous blog post, we have seen how the extension hypopg can be helpful in creating hypothetical indexes in PostgreSQL. If you have read it already, you know that it is very useful in verifying whether an Index can improve the performance of an SQL without...
by Jobin Augustine | Jul 16, 2019 | PostgreSQL
BRIN Index was introduced in PostgreSQL 9.5, but many users postponed the usage of it in their design and development just because it was “new”. But now we understand that it has stood the test-of-time! It is time to reconsider BRIN if you have not done it yet. I...
by Jobin Augustine | Jul 10, 2019 | PostgreSQL
WAL retention is a very important topic for PostgreSQL database management. But very often we come across DBAs getting into surprise situations such as: 1. Several TBs of WALs piled up in archive destination 2. WALs filling up pg_wal/pg_xlog directory due to failing...
by Ibrar Ahmed | Jul 1, 2019 | PostgreSQL
I want to thank everybody who attended my session “Deep Dive in PostgreSQL Indexes” in Austin. It was quite a wonderful experience! To cover a bigger audience, I also did a webinar on the same topic. There were many questions in that webinar, but unfortunately, there...
by Jobin Augustine | Jun 24, 2019 | PostgreSQL
Introduction Those DBAs who are experts in one database system look for other database systems to have “similar features”. It is a human tendency to look at any new technology and compare it with a world they are familiar with. Most of the time, I keep...
by Avinash Vallarapu | Jun 21, 2019 | PostgreSQL
At recent conferences, we have received a curious question from users who have used Oracle in the past and are now using PostgreSQL: “Do we have hypothetical indexes in PostgreSQL ?”. The answer to that question is EXPLAIN <QUERY>. However, if you...
