Re: Embedded text column versus referenced text - Mailing list pgsql-general

From Vick Khera
Subject Re: Embedded text column versus referenced text
Date
Msg-id AANLkTincrV-UJOkFhkcWBgtLqz_o7LKm9HEW4iKdebXO@mail.gmail.com
Whole thread Raw
In response to Embedded text column versus referenced text  (Rikard Bosnjakovic <rikard.bosnjakovic@gmail.com>)
List 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 by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: killing idle attaches without killing others
Next
From: Tom Lane
Date:
Subject: Re: hashtable issue - HASH_FIND??