Hacker News new | ask | show | jobs
by busymom0 1097 days ago
Regarding json/text instead of jsonb,

https://medium.com/geekculture/postgres-jsonb-usage-and-perf...

Says that jsonb is better suited for my needs as I need it to be indexed for lots of searching. Almost all my queries will have a where clause on this jsonb column.