Feb 04, 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 the
pg_repack extension, available in PostgreSQL for this requirement. pg_repack is a well-known extension that was […]
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 prosperous 2019. PostgreSQL has been a […]
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 posts, PostgreSQL Backup Strategy, Streaming Replication in PostgreSQL and Faster PITR in PostgreSQL where we […]
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 November 8, 2018. PostgreSQL releases minor versions with several bug fixes and feature enhancements […]
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 over forty questions during the webinar but were only able to tackle […]
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 PostgreSQL as a strong open source alternative. Without further ado, let’s have a […]
Oct 09, 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 availability, connection pooling and load balancing, extensions, and detailed logging in PostgreSQL. Tomorrow, Wednesday, October 10 at 10AM EST, […]
Oct 08, 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 log analyzer Like other RDBMS, PostgreSQL allows you to maintain a log of activities and error […]
Oct 05, 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 get to review some of the most popular open source extensions for PostgreSQL, used to expand […]
Oct 02, 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 accommodate an increase in traffic while maintaining the quality of the service (response time)? The […]
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, and cover some options available to achieve high availability in PostgreSQL. […]
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 post of this series, in our webinar of October 10, 2018 we highlight important […]
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 demonstrate an enterprise-grade PostgreSQL environment built using a combination of open source tools and extensions. Register Now “We […]
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 replication between 2 heterogeneous databases like MySQL and PostgreSQL? […]
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 postgres, and the internals you to know to maintain a […]
Aug 06, 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 consider the case of an Oracle or a MySQL Database. What happens when you perform a DELETE or an […]
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? Fortunately, the answer to these questions is […]
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 praised even by the PostgreSQL community. So when Avi joined the team […]