News for hackers. Stuff that matters.
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.

There are no comments on this comment yet.