Postgres Pro
Downloads
Home   >   mailing lists

Re: Database schema for "custom fields" - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Database schema for "custom fields"
Date
Msg-id CAKAnmmKsOc=qoPo8XeR2ayTgRHwn8O747mxtohDc59Bbq4_e8w@mail.gmail.com
Whole thread Raw
In response to Database schema for "custom fields"  (Matthias Leisi <matthias@leisi.net>)
List pgsql-general
Tree view
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

pgsql-general by date:

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