Re: data model one large and many small columns

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: data model one large and many small columns
Дата
Msg-id CAKFQuwZmyNjEkVgno=GzA6S9vo-skrqtk5FfJ==o-YOE++tkNg@mail.gmail.com
обсуждение исходный текст
Ответ на data model one large and many small columns  ("Campbell, Lance" <lance@illinois.edu>)
Список pgsql-admin
Дерево обсуждения
On Tue, Jul 26, 2016 at 4:22 PM, Campbell, Lance <lance@illinois.edu> wrote:

Is there any performance to be gained from PostgreSQL by storing the data as two tables versus one table?


​PostgreSQL already does this for you via the TOAST mechanism you mentioned.

https://www.postgresql.org/docs/9.6/static/storage-toast.html

David J.

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

Предыдущее
От: Scott Whitney
Дата:
Сообщение: Re: data model one large and many small columns
Следующее
От: Tom Lane
Дата:
Сообщение: Re: data model one large and many small columns