Re: Composite types as columns used in production?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Composite types as columns used in production?
Дата
Msg-id 7094.1114795433@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Composite types as columns used in production?  (James Robinson <jlrobins@socialserve.com>)
Список pgsql-general
James Robinson <jlrobins@socialserve.com> writes:
> That said -- anyone stepping up to claiming using 'em? Are these things
> seen as against the data normalization grain?

One strike against 'em is the fairly high overhead involved --- a
composite value is stored as effectively its own tuple, so there's 28 or
so bytes of overhead for each one.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Chris Browne
Дата:
Сообщение: Slowness of Big Graphical Arrays
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Increasing statistics results in worse estimates