Unstructured Datatypes in Postgres – Hstore vs. JSON vs. JSONB
We store key/value pairs in Hstore, since JSONB wasn't available when we started doing this.We've since updated to PostgreSQL 9.5. Does anyone know if we would see a performance advantage switching this to JSONB (either in selects or updates).My sense is no, but I haven't been able to find any good answers one way or the other. If it's yes, then HStore doesn't really serve any purpose at all anymore.