Re: Index for range queries on JSON (user defined fields)

2020-12-05 Thread Marco Colli
Thanks for the suggestion: I had already considered that solution (first link), but the fear is having to JOIN large tables with hundreds of millions of records. For my understanding **using JOIN when dealing with big data is bad and a nightmare for performance**: can you confirm? Or am I missing

Re: Index for range queries on JSON (user defined fields)

2020-12-04 Thread Nick Cleaton
On Fri, 4 Dec 2020 at 15:39, Marco Colli wrote: > Hello! > > We have a multi-tenant service where each customer has millions of users > (total: ~150M rows). Now we would like to let each customer define some > custom columns for his users and then let the customer search his users > efficiently b