From: | Ian Zimmerman <itz(at)very(dot)loosely(dot)org> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: JSONB Array of Strings (with GIN index) versus Split Rows (B-Tree Index) |
Date: | 2019-02-04 21:44:25 |
Message-ID: | 20190204214425.k3cxfkrj4exof65n@matica.foolinux.mooo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2019-02-04 22:02:44 | Re: JSONB Array of Strings (with GIN index) versus Split Rows (B-Tree Index) |
Previous Message | Adrian Klaver | 2019-02-04 15:53:13 | Re: Server goes to Recovery Mode when run a SQL |