Search Postgresql Archives

Re: Embedded text column versus referenced text

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Aug 4, 2010 at 11:05 AM, Rikard Bosnjakovic
<rikard.bosnjakovic@xxxxxxxxx> 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.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux