3 ms·
Doesn't postgress have a way to index JSONB if needed?
by machiaweliczny 5y ago
Doesn't postgress have a way to index JSONB if needed?
- sgk284 5y agoYou can index on fields in JSONB, but I don’t believe that’s what the op is solving for here. In either scenario, I’d still generally encourage avoiding storing JSON(B) unless there isn’t a better alternative. There are a lot of maintenance, size, I/O, and validation disadvantages to using JSON in the DB.