3 ms·
That's some pretty good stuff, right there. Out of curiosity, any reason you're using HSTORE instead of JSON? I've been watching what contexts JSON gets used in
by bonesmoses 12y ago
That's some pretty good stuff, right there. Out of curiosity, any reason you're using HSTORE instead of JSON? I've been watching what contexts JSON gets used in PostgreSQL systems, and having another data point never hurts. :)
- acveilleux 12y agoFrom what I can tell... HSTORE vs. JSON: Lower storage overhead, faster operations on stored data. HSTORE vs. JSONB: Significantly lower storage overhead but more limited
- pgaddict 12y agoJSON is just a TEXT data type with validation, while HSTORE stores the data in a structured way and allows a more flexible indexing and such stuff. OTOH it's just text=>text while JSON format allows additional data types. That changed with JSONB, which got introduced in 9.4 - that's essentially HSTORE2, with additional improvements.