5 ms·

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 not

by sv12l 8y ago

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?

netcraft 8y ago
You can get around that with functional indexes https://blog.anayrat.info/en/2017/11/26/postgresql---jsonb-and-statistics/ 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.
- ris 8y ago
  But ... once you're deciding what expression indexes to add you effectively have a schema, yeah?
  - qaq 8y ago
    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.