Re: Composite type storage overhead

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Composite type storage overhead
Дата
Msg-id CAHOFxGqhV-womDiquSgVYw5o8WEsGU1UcfYbT4wUViMfbJ_--Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Composite type storage overhead  (Laiszner Tamás <t.laiszner@outlook.com>)
Список pgsql-general
On Thu, Oct 24, 2019 at 3:35 AM Laiszner Tamás <t.laiszner@outlook.com> wrote:

Thanks for the suggestion to split up the primary key into components. But even going down this way, packing the components into one superstructure (composite type) would be beneficial as the same scheme is used across multiple tables. And we are back at the original problem.


This is probably a completely naive question, but why not store this in a text field?

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Quere keep using temporary files
Следующее
От: Alexander Farber
Дата:
Сообщение: Re: Trying to fetch records only if preceded by at least another one