title

text

Markus Nullmeier
Markus Nullmeier
16:00 17 March
45 min

Accelerating queries of set data types with GIN, GiST, and custom indexing extensions

Sets are apparently a useful data type for many kinds of applications. While PostgreSQL offers no built-in set data type, sets may be emulated to some degree with its built-in array and JSONB data types. Also, acceleration of respective containment (subset) queries is readily available as a built-in feature of the GIN index type.

Starting with the above, we will then explore the performance gains enabled by custom set data types, and especially by customisation code in C ("operator classes") for the GIN and GiST index types.

Slides

Other talks