GIN Archives - 2ndQuadrant

Posts

Full-text search since PostgreSQL 8.3

November 5, 2020/0 Comments/in 2ndQuadrant, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas Vondra

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 by pgbench tests. The second part looked at analytical / BI queries, using a subset of the traditional TPC-H benchmark (essentially a portion of the […]

On the usefulness of expression indexes

April 19, 2016/0 Comments/in 2ndQuadrant, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas Vondra

When teaching PostgreSQL trainings, both on basics and advanced topics, I often find out the attendees have very little idea how powerful the expression indexes may be (if they are aware of them at all). So let me give you a brief overview. So, let’s say we have a table, with a range of timestamps […]

JSONB type performance in PostgreSQL 9.4

March 3, 2015/13 Comments/in Marco's PlanetPostgreSQL /by Marco Nenciarini

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

February 23, 2015/1 Comment/in Giuseppe's PlanetPostgreSQL /by 2ndQuadrant Press

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 […]

Read 2ndQuadrant’s response to the COVID – 19 emergency here

Posts

Full-text search since PostgreSQL 8.3

On the usefulness of expression indexes

JSONB type performance in PostgreSQL 9.4

NoSQL with PostgreSQL 9.4 and JSONB

Support & Services

Products

Postgres Learning Center

About Us