Untangling the PostgreSQL upgrade

PostgreSQL 9.6 has just been released and most of the postgres users will start asking themselves how to upgrade to the new major version. This post has the intention of showing different procedures for upgrading your PostgreSQL server. Upgrading to a new major version is a task which has a high ratio of preparation over […]

Conference isn’t enough?! Join us for post-conference training!

Did you know – 2ndQuadrant has the largest single, collection of PostgreSQL experts of any company globally?! With a team of some of the best known developers, they all still actively contribute to the progressive development of PostgreSQL. Would you like to have access to some of the most knowledgeable and experienced people available? The […]

Second Edition of 5432…MeetUs!

The second edition of the 5432…MeetUs! conference is sure to be one to remember.  They will be hosting PostgreSQL experts, users, and contributors from all over the world.  With talks, workshops, and trainings – we are sure to stay busy every minute! With speakers like Zalando’s Valentine Gogichasvili and IBM’s Andrea Vercellini, it will be […]

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 for the exchange of data via web services. It is useful to perform a number of tests to verify its actual performance.

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 a data structure in a “key-value” array, dictionary style (widely used in the field of development) and, at the same time, ensures all the advantages […]