3 ms·
Or alternately: Why wasn't the JSON parsed into normal form if the intent was to search & filter across that data.
by meritt 12y ago
Or alternately: Why wasn't the JSON parsed into normal form if the intent was to search & filter across that data.
- gdulli 12y agoTo get the same flexibility you'd want from a nosql data store. Without giving up the simpler, more open access methods. The schema is partly predictable (and indexed or fielded on those parts) and partly unpredictable.
- ddorian43 12y agowhy not add the partly predicted keys as columns ? also jsonb will require a little more storage is 8tb in 1 tablespace/db ?