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

On 2019-02-04 05:34, Syed Jafri wrote:

> |---------------------|------------------|---------------------|------------------|
> |      Receiver       |       Event      |         Date        |      Location    |
> |---------------------|------------------|---------------------|------------------|
> |       Alpha         |         3        |          12         |         USA      |
> |---------------------|------------------|---------------------|------------------|
> |       Bravo         |         3        |          12         |         USA      |
> |---------------------|------------------|---------------------|------------------|
> |       Charlie       |         3        |          12         |         USA      |
> |---------------------|------------------|---------------------|------------------|

Please forgive a naive question, but doesn't this simply cry out for a
normalization step?

EventID   Date   Location
3         12     USA

Receiver  EventID
Alpha     3
Bravo     3
Charlie   3

If you want to use JSON by any means necessary, perhaps a simpler
key/value store is more appropriate than a relational DB like Postgres?

-- 
Please don't Cc: me privately on mailing lists and Usenet,
if you also post the followup to the list or newsgroup.
To reply privately _only_ on Usenet and on broken lists
which rewrite From, fetch the TXT record for no-use.mooo.com.