On Sun, Feb 3, 2019 at 10:35 PM Syed Jafri <syed.jafri2@xxxxxxxxxxx> wrote: > · Receiver names are of the type (a-z, 1-5, .) > > · 95% of all queries currently look like this: SELECT * FROM table WHERE Receiver = Alpha, with the new format this would be SELECT * FROM table WHERE receivers @> '"Alpha"'::jsonb; > 3. Which option is more efficient? Which is faster? I'd probably develop a performance test for the model and planned queries and experiment with: 1. text arrays 2. jsonb arrays 3. partitioning David J.
