Domains vs data types
Ertan Küçükoglu <ertan.kucukoglu@gmail.com>
From: Ertan Küçükoglu <ertan.kucukoglu@gmail.com>
To: pgsql-general@lists.postgresql.org
Date: 2025-08-20T04:47:43Z
Lists: pgsql-general
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 of performance gain/loss. For example I might have table defined as below create table test ( a integer, b integer, c integer, d varchar(5) ); I might also have ame table defined as below create domain aint integer; create domain s5 varchar(5); create table test_domain ( a aint, b aint, c aint, d s5 ); 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? Thanks & Regards, Ertan