Re: Domains vs data types

> On 20 Aug 2025, at 7:47 AM, Ertan Küçükoglu <ertan.kucukoglu@gmail.com> wrote:
>
> Hello,
>
> I am using PostgreSQL 17.6.
> I would like to learn if there is any benefit of using domains over data types for table column definitions in terms
ofperformance gain/loss. 
>


I know that this doesn’t answer your question, but before exploring custom types / domains,
and based on experience, I’d strongly recommend exploring jsonb instead as an alternative.

Also note that using custom types can lead to some confusion initially for basic stuff
you can’t do things like SELECT mytype.f1 and instead you have to do (mytype).f1
Things like this can get annoying pretty quickly.