Re: [GENERAL] Embedded text column versus referenced text

2010-08-04 Thread Craig Ringer
On 04/08/10 23:05, Rikard Bosnjakovic wrote: > I am in the design phase of a new db so I cannot test queries using > explain/analyze yet, but regarding performance, is there any > difference in doing this: > > CREATE TABLE something (name text, age smallint, ...other columns..., > comment text); >

Re: [GENERAL] Embedded text column versus referenced text

2010-08-04 Thread Vick Khera
On Wed, Aug 4, 2010 at 11:05 AM, Rikard Bosnjakovic 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 n