3 ms·

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/

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.