The EDB Blog

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

Bruce Momjian

4 Tips for Postgres Administration

Bruce Momjian Dec 5, 2017

Postgres Alerts It is cool to be able to stare at colorful graphs to see what Postgres is doing, but sometimes you just want to setup something, walk...

PERCENT_RANK Vs. CUMM_DIST

Bruce Momjian Nov 14, 2017

During research for my Postgres Window Magic talk, I studied the unusual behavior of percent_rank and cumm_dist (cumulative distribution). The...

Storing the Original Time Zone

Bruce Momjian Nov 7, 2017

In a previous blog entry I suggested storing the original time zone offset in a separate column if clients need to know the stored time in the...

Materialized Views and Foreign Data Wrappers

Bruce Momjian Oct 31, 2017

.inline-cta { margin: 11px 0; } .inline-cta.cta-tall { margin: 30px 0; } .inline-cta b { font-size: 18px; } You might know that Postgres supports...

Session State Failover

Bruce Momjian Oct 23, 2017

On the server side, high availability means having the ability to quickly failover to standby hardware, hopefully with no data loss. Failover behavior...

Playing with IPv6

Bruce Momjian Oct 17, 2017

Now that everyone is using IPv6 () it might be time to start playing with it. Postgres has had full IPv6 support for years, so Postgres is a good...

Odd Month Arithmetic

Bruce Momjian Oct 10, 2017

You might be aware of the interval data type, which allows mathematical operations on date, time, and timestamp values. This can lead to odd behavior...

Use with Time Zone

Bruce Momjian Oct 3, 2017

If you often use the timestamp data type, you might not be making full use of it. In these queries: CREATE TABLE tztest (x TIMESTAMP); INSERT INTO...

PL/Java Adoption

Bruce Momjian Sep 19, 2017

PL/Java has been around since 2005, but it has regularly struggled to gain users. Unfortunately, a lot of these problems are specific to the Java...

When to Use Server-Side Logic

Bruce Momjian Sep 12, 2017

The use of server-side logic, particularly stored procedures, has been a highly contentious topic among database professionals for decades. The...