Query on json / jsonb column super slow. Can I use an index?
I am trying to speed up the querying of some json data stored inside a PostgreSQL database. I inherited an application that queries a PostgreSQL table called data with a field called value where value is blob of json of type jsonb . It is about 300 rows but takes 12 seconds to select this data from the 5 json elements. The json blobs are a bit large but the
