by Avinash Vallarapu | Feb 1, 2024 | Insight for DBAs, PostgreSQL
This blog was originally published in September 2018 and was updated in Feburary of 2024Configuring replication between two databases is considered to be the best strategy for achieving high availability during disasters and provides fault tolerance against unexpected... by Avinash Vallarapu | Jul 2, 2023 | Insight for DBAs, PostgreSQL
This blog was originally written in September 2018 and was updated in June 2023.In this post, we cover the methods used to achieve an enterprise-grade backup strategy for the PostgreSQL cluster. In setting up our demonstration system, we use pg_basebackup and... by Avinash Vallarapu | Jan 24, 2023 | MongoDB, PostgreSQL
This post was originally published in 2019 and was updated in 2023.I presented at Percona University São Paulo about the new features in PostgreSQL that allow the deployment of simple shards. I’ve tried to summarize the main points in this post, as well... by Avinash Vallarapu | Sep 22, 2020 | Monitoring, Percona Software, PostgreSQL, Security
I have previously written a blog post on the detailed steps involved in enabling PostgreSQL monitoring using PMM. In that post, you could see me talking about the role: pg_monitor that can be granted to monitoring users. The pg_monitor role restricts a monitoring user... by Avinash Vallarapu | 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... 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 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 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 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... by Avinash Vallarapu | Jun 14, 2019 | PostgreSQL
There is a wide variety of indexes available in PostgreSQL. While most are common in almost all databases, there are some types of indexes that are more specific to PostgreSQL. For example, GIN indexes are helpful to speed up the search for element values within... by Avinash Vallarapu | May 13, 2019 | PostgreSQL
Usually, the PostgreSQL Community releases minor patches on the Thursday of the second week of the second month of each quarter. This can vary depending on the nature of the fixes. For example, if the fixes include critical fixes as a postgres community response to... by Avinash Vallarapu | Apr 26, 2019 | Insight for DBAs, PostgreSQL, Webinars
Please join Percona’s PostgreSQL Support Technical Lead, Avinash Vallarapu and Senior Support Engineers, Fernando Laudares, Jobin Augustine and Nickolay Ihalainen as they demonstrate the methods to upgrade a legacy version of PostgreSQL to a newer version using... by Avinash Vallarapu | Apr 12, 2019 | PostgreSQL
When you need to upgrade your PostgreSQL databases, there are a number of options available to you. In this post we’ll take a look at how you can upgrade PostgreSQL versions using pg_upgrade, a built-in tool that allows in-place upgrade of your software. Using... by Avinash Vallarapu | Apr 4, 2019 | PostgreSQL
When you need to upgrade PostgreSQL, there are a variety of approaches that you can use. To avoid application downtime, then not all of the options to upgrade postgres are suitable. When avoiding downtime is essential, then you might consider using replication as a... by Avinash Vallarapu | Mar 27, 2019 | PostgreSQL
In this blog post, we will explore pg_dump / pg_restore, one of the most commonly used options for performing a PostgreSQL upgrade. It is important to understand the scenarios under which pg_dump and pg_restore utilities will be helpful.This post is the second... by Avinash Vallarapu | Mar 18, 2019 | PostgreSQL
There are several approaches to assess when you need to upgrade PostgreSQL. In this blog post, we look at the option for upgrading a postgres database using pg_dumpall. As this tool can also be used to back up PostgreSQL clusters, then it is a valid option for... by Avinash Vallarapu | Mar 4, 2019 | PostgreSQL
A date for your diary. On Wednesday, April 17 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4) Percona’s PostgreSQL Support Technical Lead, Avinash Vallarapu and Senior Support Engineers, Fernando Laudares, Jobin Augustine and Nickolay Ihalainen, will... by Avinash Vallarapu | Feb 22, 2019 | PostgreSQL
In case you didn’t already see this news, PostgreSQL has got its first minor version released for 2019. This includes minor version updates for all supported PostgreSQL versions. We have indicated in our previous blog post that PostgreSQL 9.3 had gone EOL, and...