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
