Re:Ask HN: Have you ever chosen Postgres over Mongo and regr...
by sv12l on Tuesday July 10, 2018 @09:04AM
(#17497664)
Just checking, as far as I understand, at the moment Postgres can't add statistics on the JSONB type. Did that affect your query optimizer by any chance? or noticed any degradation in performance?
[ Parent
| on HN ]
Re:Ask HN: Have you ever chosen Postgres over Mongo and regr...
by netcraft on Tuesday July 10, 2018 @09:16AM
(#17497758)
You can get around that with functional indexes https://blog.anayrat.info/en/2017/11/26/postgresql---jsonb-a...
I'm not working with tens of millions of records, but I haven't needed to go beyond GIN indexes yet - might just be our documents or our workload though. ymmv.