Re: JSONB Array of Strings (with GIN index) versus Split Rows (B-Tree Index)

2019-02-04 Thread David G. Johnston
On Sun, Feb 3, 2019 at 10:35 PM Syed Jafri 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"'

Re: JSONB Array of Strings (with GIN index) versus Split Rows (B-Tree Index)

2019-02-04 Thread Ian Zimmerman
On 2019-02-04 05:34, Syed Jafri wrote: > |-|--|-|--| > | Receiver | Event | Date| > Location| > |-|--|-|--