by Avinash Vallarapu | Feb 4, 2019 | Insight for DBAs, PostgreSQL
In this blog post, we’ll look at how to use pg_repack to rebuild PostgreSQL database objects online.We’ve seen a lot of questions regarding the options available in PostgreSQL for rebuilding a table online. We created this blog post to explain... by Avinash Vallarapu | Dec 31, 2018 | Open Source, PostgreSQL
In this blog post, we’ll look back at what’s been going on in the world of PostgreSQL in 2018.Before we start talking about the good things that have happened in the PostgreSQL in 2018, we hope you had a wonderful year and we wish you a happy and... by Avinash Vallarapu | Dec 21, 2018 | Insight for DBAs, PostgreSQL
pg_basebackup is a widely used PostgreSQL backup tool that allows us to take an ONLINE and CONSISTENT file system level backup. These backups can be used for point-in-time-recovery or to set up a slave/standby. You may want to refer to our previous blog... by Avinash Vallarapu | Nov 16, 2018 | Insight for DBAs, PostgreSQL
In this blog post we’ll look at what the newly-released PostgreSQL minor versions contain. You probably want to update your current versions and use these updates. You might already have seen that they released the updates for supported PostgreSQL versions on... by Avinash Vallarapu | Oct 19, 2018 | PostgreSQL, Webinars
Hello everyone, and thank you to those that attended our webinar on Building an Enterprise-grade PostgreSQL setup using open source tools last Wednesday. You’ll find the recordings of such as well as the slides we have used during our presentation here.We had... by Avinash Vallarapu | Oct 18, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
You may be aware that the new major version of PostgreSQL has been released today. PostgreSQL 11 is going to be one of the most vibrant releases in recent times. It incorporates many features found in proprietary, industry-leading database systems, further qualifying... by Avinash Vallarapu | Oct 9, 2018 | Monitoring, Percona Software, PostgreSQL, Webinars
This is the last post in our series on building an enterprise-grade PostgreSQL set up using open source tools, and we’ll be covering monitoring.The previous posts in this series discussed aspects such as security, backup strategy, high... by Avinash Vallarapu | Oct 8, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
In this penultimate post from our series on building an enterprise-grade PostgreSQL environment we cover the parameters we have enabled to configure detailed logging in the demo setup we will showcase in our upcoming webinar. Detailed logging in PostgreSQL and... by Avinash Vallarapu | Oct 5, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
In this current series of blog posts, we have been discussing various relevant aspects when building an enterprise-grade PostgreSQL setup, such as security, back up strategy, high availability, and different methods to scale PostgreSQL. In this blog post, we’ll... by Avinash Vallarapu | Oct 2, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
In the previous blog posts in this series, we’ve covered some of the essential aspects of an Enterprise-grade solution: security, high availability, and backups. Another important aspect is the scalability of the solution: as our application grows how do we... by Avinash Vallarapu | Sep 28, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
High availability (HA) and database replication is a major topic of discussion for database technologists. There are a number of informed choices to be made to optimize PostgreSQL replication so that you achieve HA. In this post we introduce an overview of the topic,... by Avinash Vallarapu | Sep 21, 2018 | Insight for DBAs, Insight for Developers, Percona Events, PostgreSQL, Security
In this post, we review how you can build an enhanced and secure PostgreSQL database environment using community software. We look at the features that are available in PostgreSQL that, when implemented, provide improved security.As discussed in the introductory blog... by Avinash Vallarapu | Sep 14, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL, Webinars
Please join Percona’s PostgreSQL Support Technical Lead, Avinash Vallarapu; Senior Support Engineer, Fernando Laudares; and Senior Support Engineer, Jobin Augustine, on Wednesday, October 10th, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4), as they... by Avinash Vallarapu | Aug 17, 2018 | Insight for DBAs, MySQL, PostgreSQL
Replication is one of the well-known features that allows us to build an identical copy of a database. It is supported in almost every RDBMS. The advantages of replication may be huge, especially HA (High Availability) and load balancing. But what if we need to build... by Avinash Vallarapu | Aug 10, 2018 | Insight for DBAs, PostgreSQL
The performance of a PostgreSQL database can be compromised by dead tuples since they continue to occupy space and can lead to bloat. We provided an introduction to VACUUM and bloat in an earlier blog post. Now, though, it’s time to look at autovacuum for... by Avinash Vallarapu | Aug 6, 2018 | Insight for DBAs, PostgreSQL
Implementation of MVCC (Multi-Version Concurrency Control) in PostgreSQL is different and special when compared with other RDBMS. MVCC in PostgreSQL controls which tuples can be visible to transactions via versioning. What is versioning in PostgreSQL? Let’s... by Avinash Vallarapu | Jun 28, 2018 | Insight for DBAs, PostgreSQL
The need to recover a database back to a certain point in time can be a nerve-racking task for DBAs and for businesses. Can this be simplified? Could it be made to work faster? Can we recover to a given point in time with zero loss of transactions/records?... by Avinash Vallarapu | Jun 15, 2018 | Benchmarks, PostgreSQL
Percona has a long tradition of performance investigation and benchmarking. Peter Zaitsev, CEO and Vadim Tkachenko, CTO, led their crew into a series of experiments with MySQL in this space. The discussion that always follows on the results achieved is well known and...