Partition Pruning in EDB Postgres 9.5

One of my colleagues who was recently working with a customer has presented a customer case. According to him, the customer has a partitioned table and EDB Postgres™ was not...
December 22, 2016

Collaboration Makes Postgres Better for Everyone

I recently went to PGConf.EU, the European PostgreSQL conference that was held in Tallinn, Estonia on November 1-4. This annual event for Postgres developers and users is a great opportunity...
November 16, 2016

How to Be the Master of Your Database Domain

The increasing deployment of Postgres has brought about new demands for features, capabilities, and tools from developers and database administrators. As the leading Postgres database platform company, EnterpriseDB® (EDB™) works...
November 16, 2016

Analyzing Postgres Adoption

As an open source project, the Postgres community has always had great difficulty in measuring many aspects of Postgres adoption. For example, how many people use Postgres? We don't know...
November 16, 2016

Uber's Move Away from PostgreSQL

Last week, a blog post by an Uber engineer explained why Uber chose to move from PostgreSQL to MySQL. This article was widely reported and discussed within the PostgreSQL community...
November 16, 2016

An Illustration of JSONB Capabilities in Postgres 9.5

Postgres introduced JSON and JSONB in versions 9.3 and 9.4, respectively, with JSONB (Binary Javascript Object Notation) being the canonical form of JSON, stored as binary objects with improved compression...
November 16, 2016

Be Prepared for Prepare

Prepared statements are queries where the constants used in the query are separated from the query text. While this improves security by avoiding SQL injection attacks, it also allows repeatedly-executed...
November 16, 2016