Will note that json/text columns are better than jsonb. Lower serialization overheads and surprisingly smaller binary size. Or better yet, just normalize to a columnar format.
Will note that json/text columns are better than jsonb. Lower serialization overheads and surprisingly smaller binary size. Or better yet, just normalize to a columnar format.
In other words Postgres is actually kind of expensive for serious use despite being “free.” It’s just something to be aware of. Kubernetes is another “free” system with this nature.
If I were starting a new project today I would look hard at cockroachdb. Its license is on paper less free than Postgres but in practice it’s more free for many use cases, and it’s a modern raft database with auto failover and pretty easy scaling.
Postgres feels like something from 1980s Unix. Everything is manual and clunky and very arcane.
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.