• 2 Posts
  • 14 Comments
Joined 2 years ago
cake
Cake day: June 13th, 2023

help-circle





  • The query speed isn’t quite there but I would say it’s close enough for a lot of purposes, especially with proper indexing. And JSON column fields are indexable. Two things I’ve used Postgres’ JSON functionality for are:

    1.) Storing unstructured data. 2.) Storing structured data that would exceed the table column limit.

    In both cases, I’ve typically needed to extract the relevant data from the JSON records to either be stored in another table of turned into a materialized view so live query performance on the JSON columns was not that important.