This article discusses how to perform benchmark tests using the open source tool, HammerDB, as an alternative to using pgbench. We will review: Hardware specifications Operating system configurations PostgreSQL configurations Benchmarking specifications Benchmarking results The standard tool used to benchmark PostgreSQL is pgbench. In an earlier post, we discussed how we can tune and benchmark...

There is no question that PostgreSQL adoption is increasing exponentially. Organizations of all sizes are deploying PostgreSQL for a variety of database workloads. As a result, you can find PostgreSQL everywhere—in your OS with Red Hat Enterprise Linux, Ubuntu, SUSE; on your platform in VMware, Heroku, Docker Hub; in your public cloud providers as a service, and even on Kubernetes distributions, such as Red Hat OpenShift.

In this post, we dig into why it's essential to monitor Postgres, and how to do it effectively

This technical blog explains how CREATE INDEX CONCURRENTLY (CIC) works and how it manages to avoid locking the table from updates. A unique distinguishing factor of CIC is that it can build a new index on the table, without blocking it from updates/inserts/deletes.

Deciding on a development framework for a new project is often done ad hoc, based on the available expertise and personal preferences of the developers involved in the project. However, the more rational approach for an enterprise would involve looking at specific criteria that the development framework should satisfy. The “general science” of making such a choice is simple and well-established...

Technical Alert/Update Information Technical Alert Name EDB Technical Update for PostgresTM Migration Portal 2.5.0 Product Type EDB Postgres Migration Portal Release Date 2/7/2020 Technical Alert Details TECHNICAL UPDATE EDB Postgres TM Migration Portal 2.5.0 WHAT’S NEW This update is notifying you of a new software release EDB Postgres TM Migration Portal 2.5.0. EDB Postgres™ Migration Portal...

Where is EDB this month? A better question is ‘where isn’t EDB this month?’ with seven Postgres-related events taking place in Asia, Europe and North America.

Back in November last year Gartner launched its State of the Open-Source DBMS Market 2019 report and declared 1: "By 2022, more than 70% of new in-house applications will be developed on an Open Source Database Management System (OSDBMS) or OSDBMS-based Database Platform-as-a-Service (dbPaaS), and 50% of existing proprietary Relational Database Management Systems (RDBMS) instances will have been...

If you’re an enterprise, additional tools and capabilities are needed to run your mission-critical applications at scale. EnterpriseDB is a long-time supporter of the PostgreSQL open source project, making major feature contributions every year since 2006. We draw from our in-depth understanding of the technology to add features, capabilities and support around the PostgreSQL database in order to support enterprise applications.

Ed Boyajian was interviewed for the Open Source Underdogs podcast, which features leaders from companies that use open source as part of their business model. The host, Mike Schwartz, says “I got a lot of great insights from this interview. And I feel like I only scratched the surface.” We agree. No single company owns Postgres Ed and Mike cover a gamut of topics starting with EDB’s relationship...