logoalt Hacker News

martinaldyesterday at 11:35 AM2 repliesview on HN

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


Replies

jjiceyesterday 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
d0100yesterday 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