Re: Column as arrays.. more efficient than columns?

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Column as arrays.. more efficient than columns?
Date: 2007-09-07 01:20:08
Message-ID: F78B26BC-B827-43EF-B81D-DC5A10068227@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Sep 6, 2007, at 19:58 , Ow Mun Heng wrote:

> Don't denormalise the table?

Yes. Don't denormalize the tables.

> don't put them into arrays?

Yes. Don't use arrays. Caveat: if the data is *naturally* an array
and you will not be doing any relational operations on individual
elements of the arrays, then it makes sense to use arrays. Treat
arrays as you would any other opaque type.

Michael Glaesemann
grzm seespotcode net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Browne 2007-09-07 01:45:37 Re: a provocative question?
Previous Message Tom Lane 2007-09-07 01:17:47 Re: log_statement and PREPARE