Re: Embedded text column versus referenced text

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: Embedded text column versus referenced text
Дата
Msg-id AANLkTincrV-UJOkFhkcWBgtLqz_o7LKm9HEW4iKdebXO@mail.gmail.com
обсуждение исходный текст
Ответ на Embedded text column versus referenced text  (Rikard Bosnjakovic <rikard.bosnjakovic@gmail.com>)
Список pgsql-general
On Wed, Aug 4, 2010 at 11:05 AM, Rikard Bosnjakovic
<rikard.bosnjakovic@gmail.com> wrote:
> The comments field will be used here and there but I expect it will
> most often be NULL.

If it is most often NULL it won't really take up much space in the
table.  However, if when it does have content the contents are large,
and are not relevant to the bulk of queries about the "something",
then having it separate is probably a good idea, especially if you are
using an ORM that will want to pull that data in every time you load
the object.  It really depends on how much you use the column and how
you use it.

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: killing idle attaches without killing others
Следующее
От: Tom Lane
Дата:
Сообщение: Re: hashtable issue - HASH_FIND??