The EDB Blog
The latest thought leadership pieces from EDB, including company and PostgreSQL announcements
Recent Posts
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?
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
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
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
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 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
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...
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...
How to Use EXPLAIN ANALYZE for Planning and Optimizing Query Performance in PostgreSQL
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...
Survey: The Economic Impact of COVID-19 on PostgreSQL Users
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...