Re:Using PostgreSQL’s JSONB for NoSQL (2019) [video]
by debug-desperado on Sunday September 05, 2021 @09:59PM
(#28429524)
Had a great win this last week with JSONB. Basically I needed an aggregated materialized view for performance but still have access to the non-aggregated row data. Think aggregate by account ID but the query may access any given month of data for that account. It’s cheating a bit to use a non-relational structure, but the correlated subqueries I had to use before were 20x slower.
[ Parent
| on HN ]
There are no comments on this comment yet.