The EDB Blog

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

Recent Posts

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

Konica Minolta

Why Konica Minolta Relies on Open Source PostgreSQL Database for Healthcare Providers

Adam Bunch May 4, 2020

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

How to use EXPLAIN ANALYZE for Planning and Optimizing Query Performance in PostgreSQL

How to Use EXPLAIN ANALYZE for Planning and Optimizing Query Performance in PostgreSQL

Richard Yen April 30, 2020

With many people working from home these days because of the coronavirus pandemic, it can be a little challenging to get help from a colleague...

Economic Impact of COVID-19 on PostgreSQL Users

Survey: The Economic Impact of COVID-19 on PostgreSQL Users

Frank Days April 28, 2020

At EDB, the health and safety of our employees, partners, customers, and the global community are our highest priorities. In light of the coronavirus...