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

Re:Ask HN: Have you ever chosen Postgres over Mongo and regr... by ris on Tuesday July 10, 2018 @04:12PM (#17501664)
But ... once you're deciding what expression indexes to add you effectively have a schema, yeah?
Re:Ask HN: Have you ever chosen Postgres over Mongo and regr... by qaq on Tuesday July 10, 2018 @04:24PM (#17501788)
well thats not too different from NoSQL you will get something like GIN index by default at best. In mongo you also have to create indexes.