On Sun, Feb 3, 2019 at 10:35 PM Syed Jafri <syed.jaf...@ucalgary.ca> 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.
