Where? What? Who? - Everything in one place


Working with PostgreSQL JSONB

PostgreSQL in version 9.4 introduced jsonb, a new column type for storing documents in binary JSON format. This makes it slightly slower to input due to added conversion overhead and might take more disk space to store. On the other hand it is significantly faster to process, since no reparsing is needed and supports indexing, which can be of a serious advantage.

view more