The EDB Blog

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

Bruce Momjian

Statistics on Expression Indexes

Bruce Momjian Mar 22, 2017

Most people know that Postgres allows the creation of indexes on expressions. This is helpful if you need index lookups of expressions used in where...

Getting the Most of out Application_Name

Bruce Momjian Mar 15, 2017

Application_name might be one of those Postgres settings that you have seen in various places but never understood its purpose. It is true that...

Wait Event Reporting

Bruce Momjian Mar 13, 2017

Postgres often lacks the sophisticated reporting of more established enterprise relational database systems. Sometimes that is because Postgres doesn...

Going Deep on Stats

Bruce Momjian Feb 28, 2017

Postgres includes lots of monitoring tools that allow you to see what is happening, but there are a few settings that really go into detail, e.g. log...

Creating SSL Certificates

Bruce Momjian Jan 13, 2017

Having covered the choice of certificate authorities, I want to explain the internals of creating server certificates in Postgres. The instructions...

SSL Certificates and Certificate Authorities

Bruce Momjian Jan 13, 2017

When setting up ssl in Postgres, you can't just enable ssl. You must also install a signed certificate on the server. The first step is to create a...

Controlling Autovacuum

Bruce Momjian Jan 9, 2017

.inline-cta { margin: 11px 0; } .inline-cta.cta-tall { margin: 30px 0; } .inline-cta b { font-size: 18px; } Unlike other database systems, Postgres...

Analyzing Postgres Adoption

Bruce Momjian Nov 16, 2016

As an open source project, the Postgres community has always had great difficulty in measuring many aspects of Postgres adoption. For example, how...

Be Prepared for Prepare

Bruce Momjian Nov 16, 2016

Prepared statements are queries where the constants used in the query are separated from the query text. While this improves security by avoiding SQL...

Postgres Going in Multiple Directions

Bruce Momjian Dec 18, 2015

In 2013 I blogged about Postgres advancing in multiple directions at once. Having presented my Postgres 9.5 features talk six times already (with...