The EDB Blog
Recent Posts
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
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
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
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?
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
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
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
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
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
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...

Konica Minolta
Why Konica Minolta Relies on Open Source PostgreSQL Database for Healthcare Providers
May 4, 2020

When it comes to choosing a database platform in the healthcare industry, hospitals and large healthcare providers have historically chosen the...

Top Authors
Before joining EnterpriseDB, Marc spent almost 4 years at Polycom, the leading maker of video co…
Vibhor Kumar is Chief Performance Architect wit…
Raghavendra Rao is a Managing Consultant in Professional Ser…
Ajay Patel is a Delivery Manager on the RemoteDBA team, supporting customers worldwide with both…
Senior Vice President, Marketing Frank Days is EDB's Vice President of Marketing. He h…