Full-text search since PostgreSQL 8.3

Welcome to the third – and last – part of this blog series, exploring how the PostgreSQL performance evolved over the years. The first part looked at OLTP workloads, represented...
November 05, 2020

[Video] Introduction to JSON data types in PostgreSQL

The video of my presentation below walks you through the major features of the native JSON data type in PostgreSQL 9.3 and beyond. https://www.youtube.com/watch?v=BtFes871CN0 This presentation covers the following topics...
October 07, 2018

Are we ready for Nordic PGDay?

The 3rd annual Nordic PGDay will be held on 17th of March in Helsinki this year. Registration is still open, reserve yourselves a seat before it’s too late! Nordic PGDay...
February 25, 2016

JSONB type performance in PostgreSQL 9.4

The 9.4 version of PostgreSQL introduces the JSONB data type, a specialised representation of the JSON data, allowing PostgreSQL to be competitive in managing the “lingua franca” of the moment...
March 03, 2015

NoSQL with PostgreSQL 9.4 and JSONB

The introduction of the JSONB data type in PostgreSQL, definitely makes the “NoSQL” side of this relational DBMS come out: this introduction meets the requirements of all those who prefer...
February 23, 2015