The EDB Blog

The latest thought leadership pieces from EDB, including company and PostgreSQL announcements

Recent Posts

Postgres: A Strategic Tool When Deployed Properly

Postgres: A Strategic Tool When Deployed Properly

Marc Linster June 3, 2020

This article summarizes best practices and lessons learned from working with large and mid-size companies in their deployment of Postgres. Some...

PostgreSQL Write-Ahead Logging (WAL) Tradeoffs: Bounded vs. Archived vs. Replication Slots

PostgreSQL Write-Ahead Logging (WAL) Trade-offs: Bounded vs. Archived vs. Replication Slots

Thom Brown May 28, 2020

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...

Remote DBA & Cloud DBA Services: Powering Your DBA Needs from Compute to Cloud

Remote DBA & Cloud DBA Services: Powering Your DBA Needs from Compute to Cloud

Kanchan Mohitey May 28, 2020

Postgres popularity and adoption is soaring and there is no denying the fact that Postgres has emerged as a leading choice of RDBMS in Open Source...

pgbench

Pgbench: Performance Benchmark of PostgreSQL 12 and EDB Advanced Server 12

Vibhor Kumar May 26, 2020

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...

Is it time to upgrade your PostgreSQL database?

Is it Time to Upgrade your PostgreSQL Database?

Ajay Patel May 21, 2020

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...

PgBadger: X-Ray Vision for Your Queries

PgBadger: X-Ray Vision for Your Queries

Amit Sharma May 14, 2020

Performance complaints are not entirely new to a DBA. With the large number of possible parameters and varying loads which can affect performance, it...

Key Parameters and Configuration for Streaming Replication in Postgres 12

Key Parameters and Configuration for Streaming Replication in Postgres 12

Vibhor Kumar May 14, 2020

Streaming Replication (SR) is a way of achieving High Availability with Postgres. There are many parameter settings that need to be set correctly for...

A Review of 4 Top PostgreSQL Books

A Review of 4 Top PostgreSQL Books

Marc Linster May 8, 2020

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...

Index Corruption in PostgreSQL: The Hidden Cost on your Queries

Index Corruption in PostgreSQL: The Hidden Cost of Your Queries

Ajay Patel May 7, 2020

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...

Patching Minor Version in Postgres High Availability (HA) Database Cluster: Plans & Strategies for DBAs

Patching Minor Version in Postgres High Availability (HA) Database Cluster: Plans & Strategies for DBAs

Vibhor Kumar May 5, 2020

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...