The EDB Blog

PostgreSQL

PostgreSQL is the world’s most advanced open source object-relational database management system. It was developed by the PostgreSQL Global Development Group.

Postgres: A Strategic Tool When Deployed Properly
Postgres: A Strategic Tool When Deployed Properly
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...

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

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

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

Survey: The Economic Impact of COVID-19 on PostgreSQL Users
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...

How to Benchmark PostgreSQL using HammerDB open-source tool
How to Benchmark PostgreSQL Using HammerDB Open Source Tool
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...

PostgreSQL Backup & Recovery: The Ifs, Ands & Buts
PostgreSQL Backup & Recovery: The Ifs, Ands & Buts
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
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...

Native Packaging Makes Postgres Installation More Manageable & Secure
Optimizing Performance and Security in Postgres with Platform Native Packaging
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...

Get Postgres Tips and Tricks

Subscribe to our newsletter to get advanced Postgres how-tos.

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…