Postgres 9.4 feature highlight - Indexing JSON data with jsonb data type

2014-04-06 15:36:08 +0000

PostgreSQL 9.4 is shipping with a new feature called [jsonb] (https://www.postgresql.org/docs/devel/static/datatype-json.html), which is a new data type able to store JSON data supporting GIN indexing (!). In short, this feature, one of the most important of the upcoming release, if not the most important, puts Postgres directly in good position in the field of document-oriented database systems.

Postgres 9.4 feature highlight - Triggers on foreign tables

2014-03-28 07:21:08 +0000

PostgreSQL 9.4 is coming with more support for triggers, making them now firable on foreign tables. This feature has been introduced by the following commit:

Postgres 9.4 feature highlight - Getting contexts of lock waits

2014-03-21 04:22:08 +0000

A new feature is showing up in PostgreSQL 9.4 allowing to get more information about transaction lock waits and their circumstances. It has been introduced by this commit:

Postgres 9.4 feature highlight - Physical slots for replication

2014-03-12 15:35:08 +0000

Replication slots is a new feature of PostgreSQL 9.4 that has been introduced by this commit:

Postgres 9.4 feature highlight - COPY FORCE NULL

2014-03-05 14:37:27 +0000

When using COPY, there is an option called FORCE_NOT_NULL allowing to enforce a string to be not null even if it is not quoted. Here is an example of how it works: