On Wed, Aug 20, 2025 at 12:48 AM Ertan Küçükoglu <ertan.kucuko...@gmail.com> wrote:
> Does the second table have any technical advantage/disadvantage over plain > data type definition? > Less metadata in memory? High metadata in memory? Less/increased disk > space? > Same disk space. No disadvantage other than confusing your users, and any performance differences will be so minor as to be unmeasurable. (my two cents: domains are best when the data type is complex AND shared across multiple tables. Even then I tend to avoid them.) Cheers, Greg -- Crunchy Data - https://www.crunchydata.com Enterprise Postgres Software Products & Tech Support
