This blog is part of a series of blogs on best practices for high availability. In previous blogs, we discussed What Does High Availability Really Mean, Patching Minor Version in...
Some companies start using Postgres in a single project, and it grows from there. Others get introduced to Postgres because of an acquisition or because a new off-the-shelf application runs...
This week, a customer I was working with wanted help setting wal_keep_segments—the number of extra transaction log files to keep on the primary specifically so that standbys could afford to...
In January one of my colleagues, Kuntal Gosh, shared his benchmark with current and recent versions of PostgreSQL on an AWS m5.metal instance. In his benchmark, he has shown how...
In this era of agile development, organizations are always looking to get new features into their product to be a step ahead of the competition as quickly as possible. A...
Performance complaints are not entirely new to a DBA. With the large number of possible parameters and varying loads which can affect performance, it can be a mind-numbing affair to...
Streaming Replication (SR) is a way of achieving High Availability with Postgres. There are many parameter settings that need to be set correctly for streaming replication. In this blog, we...
When I first started looking into Postgres, there were very few books in bookstores (yes, those still existed - that was a long time ago) and the only online resource...
A corruption in the database base often manifests itself in the form of errors when performing a DDL or DML operation on affected relations. The errors often show up as...
This blog is part of a series that will discuss best practices for High Availability (HA) for Postgres databases. In a prior blog, I explained what High Availability means (...