The EDB Blog

Allowing Only One Null

6/14/2017

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

Postgres Keywords

5/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, with slight...

Who Contributes to PostgreSQL Development?

4/27/2017

In a talk which I gave at PGCONF.IN and, in a shorter version, at PGCONF.US, I had a few slides on who contributes to PostgreSQL development.  Here, I'd like to present...

Column Storage Intervals

4/25/2017

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

Index Order Does Matter

4/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 are all at the...

New Features Coming in PostgreSQL 10

4/10/2017

The list of new features coming in PostgreSQL 10 is extremely impressive.  I've been involved in the PostgreSQL project since the 8.4 release cycle (2008-2009...

Still No Query Hints?

03/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 "'Oracle-style'...

Wait Event Reporting

3/13/2017

Postgres often lacks the sophisticated reporting of more established enterprise relational database systems. Sometimes that is because Postgres doesn't require as much...