3 ms·
> Does anyone know if we would see a performance advantage switching this to JSONB (either in selects or updates). I don't actually know anything from practica
by _pmf_ 10y ago
> Does anyone know if we would see a performance advantage switching this to JSONB (either in selects or updates).
I don't actually know anything from practical usage, but I think JSONB makes some kinds of membership tests more efficient (at the price of more expensive inserts). See 8.14.3. of https://www.postgresql.org/docs/9.4/static/datatype-json.html https://www.postgresql.org/docs/9.4/static/datatype-json.htm...