The EDB Blog

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

Recent Posts

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

How to Benchmark PostgreSQL using HammerDB open-source tool

How to Benchmark PostgreSQL Using HammerDB Open Source Tool

Amit Kapila April 27, 2020

This article discusses how to perform benchmark tests using the open source tool, HammerDB, as an alternative to using pgbench. We will review...

Postgres Vision 2020 Virtual

Announcing: Postgres Vision 2020 Virtual Event

Meaghan Moraes April 24, 2020

Postgres has won the hearts and minds of database operators and application developers. Especially today, Postgres represents business stability and...

PostgreSQL Backup & Recovery: The Ifs, Ands & Buts

PostgreSQL Backup & Recovery: The Ifs, Ands & Buts

Amit Sharma April 23, 2020

Backups are often taken based on suggestions and recommendations of the person who we think knows the best. We do not try to understand what...

Identify and Resolve Problems Faster by Logging PostgreSQL Activities

Identify and Resolve Problems Faster by Logging PostgreSQL Activities

Richard Yen April 20, 2020

The 18th Southern California Linux Expo (SCaLE) took place in sunny Pasadena California in March, which included a 2-day series of talks by members of...

Postgres Pulse Insights

“Sorry, too many clients already” - How to Use PgPool to Solve Database Connection Load Problems

Piyush Sharma April 16, 2020

With the ongoing crisis of COVID-19, I keep myself updated with the latest situation around the globe. The WHO’s website is one I’ve used frequently...

Native Packaging Makes Postgres Installation More Manageable & Secure

Optimizing Performance and Security in Postgres with Platform Native Packaging

Marc Linster April 15, 2020

Several years ago, EnterpriseDB (EDB) decided to deprecate the one-click installers for Linux in favor of native packages. EDB still provides and...

Postgres Pulse Insights

"I can’t get to the database! Is it down?" PostgreSQL LDAP Authentication Problems

Jamie Watt April 9, 2020

The morning begins with a new email, with this subject line at the top of the inbox of you, the trusty DBA. The database isn’t down, though, otherwise...

Top Tools to Manage Postgres in an Enterprise: Administration, Performance, High Availability, and Migration

Top Tools to Manage Postgres in an Enterprise: Administration, Performance, High Availability, and Migration

Marc Linster April 8, 2020

This blog post lists tools for managing Postgres in the enterprise for administration, performance tuning, recovery, oracle to Postgres migration and high availability. While this is a big topic, there are common denominators that we have seen in many Postgres projects.