On Tue, 2021-06-01 at 23:08 +0000, Laura Smith wrote:
> I didn't consider hstore, I did consider jsonb though.
>
> The thing that made me lean towards individual rows rather than consolidated was
> that I thought versioning would ultimately be easier/cleaner to achieve with
> individual rows (e.g. using tsrange & gist exclude). But willing to be proven wrong.
Your intuition is good. Don't use JSON for that, and don't use the outdated
hstore extension in particular.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com