Re: Database schema for "custom fields"

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: Matthias Leisi <matthias(at)leisi(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Database schema for "custom fields"
Date: 2024-09-11 13:24:16
Message-ID: CAKAnmmKsOc=qoPo8XeR2ayTgRHwn8O747mxtohDc59Bbq4_e8w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'd go with option 2 (jsonb), as it's likely already well supported by your
applications, while the other approaches will require a good bit of
customization. JSONB can be indexed, so performance should be on par with
"traditional" tables.

Cheers,
Greg

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pecsök Ján 2024-09-11 13:31:45 RE: Error:could not extend file " with FileFallocate(): No space left on device
Previous Message Greg Sabino Mullane 2024-09-11 13:19:37 Re: Logical replication without direct link between publisher and subscriber?