Categories
Products
Technologies
Top Rated docs

October 16, 2020

Using Barman for PostgreSQL Disaster Recovery

There must be many powerful tools available as a backup and restore option for PostgreSQL in general; Barman, PgBackRest, BART are to name a few in this context. What caught our attention was that Barman...

October 9, 2020

An Overview of PostgreSQL Query Caching & Load Balancing

The topic of caching appeared in PostgreSQL as far back as 22 years ago, and at that time the focus was on database reliability. Fast forward to 2020, the disk platters are hidden even deeper...

October 6, 2020

How to Upgrade PostgreSQL 11 to PostgreSQL 12 with Zero Downtime

The most intuitive database upgrade way that you can think of is to generate a replica in a new version and perform a failover of the application into it, and actually it works perfectly in...

October 1, 2020

Comparing load balancers for PostgreSQL

Load balancing increases system performance, especially from the application standpoint, allowing several computers to serve the same data. It works such that the load is being distributed among client queries to replica nodes aside from...

September 30, 2020

Scaling PostgreSQL Using Connection Poolers & Load Balancers

Scalability is the property of a system to handle a growing amount of demands by adding resources. The reasons for this amount of demands could be temporary, for example, if you are launching a discount...

September 24, 2020

Understanding the HAProxy Statistics for MySQL & PostgreSQL

Having a Load Balancer is always a good option to improve your database environment. It can help you on redirect applications to available database nodes, distribute the traffic across multiple servers to improve performance, or...

September 14, 2020

How to Achieve PostgreSQL High Availability with pgBouncer

In the database world, there are many common concepts like High Availability, Failover, and Connection pooling. All of them are useful things to implement on any system, and even a must in some cases. A...

September 9, 2020

Driving Performance for PostgreSQL with HAProxy

Database performance is a very important concern when maintaining your database cluster, especially as it grows over the time. This is especially true if your application started out with low traffic going then growting to...

September 3, 2020

Building a Highly Available Database for Moodle Using PostgreSQL

Impacted by the COVID-19 pandemic, a lot of SMBs/SMEs are transitioning to online platforms. Face-to-face or physical classes are also affected by this pandemic and a lot of schools and universities are also transitioning to...

August 27, 2020

An Overview of Trusted Extensions in PostgreSQL 13

In my previous blog, we explored new capabilities of Logical replication with Partition tables in PostgreSQL 13. Needless to say that there are multitude of such features in the mentioned release which will soon enhance...

August 25, 2020

Best DBaaS Solutions for PostgreSQL

Cloud computing is getting more and more used in all companies to take advantage of all the features offered by this technology. It allows for On-Demand availability of compute power, database, storage, applications, and other...

July 24, 2020

Logical Replication Partitioning With PostgreSQL 13

Every PostgreSQL release comes with few major feature enhancements, but what is equally interesting is that every release improves upon its past features as well. As PostgreSQL 13 is scheduled to be released soon, it’s...

Subscribe below to be notified of fresh posts