News for hackers. Stuff that matters.

A comment on We saved $50k/year with a Go microservice coded in a hackathon. Parent comment

Re:We saved $50k/year with a Go microservice coded in a hack... by zaarn on Wednesday April 11, 2018 @03:44AM (#16808891)
JSONB columns should behave just like any datatype with a GIN index in the recent releases, to my knowledge.

Still, a JSON column will arguably be faster than a pure KV table since you can more efficiently query it, especially any non-JSON columns.

[ Parent | on HN ]
Re:We saved $50k/year with a Go microservice coded in a hack... by ptman on Wednesday April 11, 2018 @05:08AM (#16809296)
IIRC JSONB still has problem with index statistics

So values in JSONB columns can be indexed nicely, but the statistics can be much worse than for non-JSONB columns, which can lead the query planner astray.

[ Parent | on HN ]