The EDB Blog

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

Bruce Momjian

Which NoSQL Database for New Project?

Bruce Momjian Aug 31, 2017

Oh, how I love the title of this 2014 Slashdot request, "Which NoSQL Database For New Project?" The user already knows the type of clients (iPhones...

You Don't Need Every Feature of Your Previous Database

Bruce Momjian Aug 8, 2017

In a March blog post I talked about the mismatch between what people expect from Postgres in terms of hints, and what exists. In this blog post I...

Outer Joins and Where Clauses

Bruce Momjian Jul 19, 2017

.inline-cta { margin: 11px 0; } .inline-cta.cta-tall { margin: 30px 0; } .inline-cta b { font-size: 18px; } Postgres supports both traditional join...

Allowing Only One Null

Bruce Momjian Jun 14, 2017

While the sql standard allows multiple nulls in a unique column, and that is how Postgres behaves, some database systems (e.g. ms sql) allow only a...

Postgres Keywords

Bruce Momjian May 17, 2017

You might be aware that the sql standard reserves certain identifiers that cannot be used for naming user objects. Postgres follows that standard...

Column Storage Intervals

Bruce Momjian Apr 25, 2017

Postgres uses native cpu alignment to store values in a row. This allows blocks to be copied unchanged from disk into shared buffers and accessed as...

Creating Descending Indexes

Bruce Momjian Apr 18, 2017

You might have noticed that create index allows you to specify asc or desc for each column being indexed, and you might have wondered why. Asc is the...

Index Order Does Matter

Bruce Momjian Apr 12, 2017

Postgres has supported multi-column indexes since 1997, e.g. create index i_test on test (a, b, c). It can easily use an index if the supplied columns...

Expression Index Statistics and Joins

Bruce Momjian Apr 5, 2017

In my previous blog post, I showed how statistics generated on expression indexes can be used to produce more accurate row counts, and potentially...

Still No Query Hints?

Bruce Momjian Mar 28, 2017

So, it is 2017 and Postgres still doesn't support query hints like other relational databases? Yep, it's true, and probably will be forever since "...