Re: Domains vs data types
| От | Greg Sabino Mullane |
|---|---|
| Тема | Re: Domains vs data types |
| Дата | |
| Msg-id | CAKAnmmJfh2hPk8v597tRNVhM9_4oCQmTtJ6CVqHAp4hO0qPj6Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Domains vs data types (Ertan Küçükoglu <ertan.kucukoglu@gmail.com>) |
| Ответы |
Re: Domains vs data types
|
| Список | pgsql-general |
On Wed, Aug 20, 2025 at 12:48 AM Ertan Küçükoglu <ertan.kucukoglu@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
В списке pgsql-general по дате отправления: