logoalt Hacker News

martinaldlast Wednesday at 11:35 AM2 repliesview on HN

Anything jsonb in my experience is quickly CPU bound...


Replies

jjicelast Wednesday at 4:26 PM

Definitely. If you're doing regular queries with filters on jsonb columns, having the index directly on the JSON paths is really powerful. If I have a jsonb filter in the codebase at all, it probably needs an index, unless I know the result set is already very small.

show 1 reply
d0100last Wednesday at 7:08 PM

I've shaved off 30s of queries by transforming json columns into a string after the first CTE is done with it