The EDB Blog

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...

Going Deep on Stats

2/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....

The Power of APIs in EDB Postgres Ark

2/6/2017

EnterpriseDB® (EDB™) created the EDB Postgres Ark™ to simplify the process of provisioning robust Postgres deployments, while also providing the benefits of cloud...