jsonb supports, unsurprisingly, JSON jsonb is, undeniably, king. It is a very flexible data type, that allows for unstructured/schema-less storage. It has very powerful indexing mechanisms, and its internal representation is reasonably compact and efficient. It comes with advanced operators and expressions to query/extract parts of it, and has recently seen the addition of SQL/JSON path functionality to extend that to comply with the SQL Standard. There are countless posts and resources explaining the virtues of this data type and what you can accomplish with it.

A comparative approach between Generated Columns and Triggers In this post, we are going to describe how Generated Columns work and how much it improves query execution times, compared to trigger-based solutions. For the test set, we analyzed the performance of INSERT and UPDATE operations using Generated Columns against C and PL/pgSQL based function triggers. This blog post includes a ready-to-go laboratory with the full battery of tests at this repository.