9 ms·
What's your opinion between jsonb vs hstore columns? https://www.postgresql.org/docs/15/hstore.html https://www.postgresql.org/docs/15/hstore.html
by nextaccountic 4y ago
What's your opinion between jsonb vs hstore columns? https://www.postgresql.org/docs/15/hstore.html https://www.postgresql.org/docs/15/hstore.html
- oliverrice 4y agoIIRC, hstore pre-dated jsonb. I'm not aware of any performance differences for the object type but it would be worth checking if you have a heavy workload. jsonb will tend to have better ORM support and it also isn't behind an extension which is a (small) perk