Re: Column as arrays.. more efficient than columns? - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: Column as arrays.. more efficient than columns?
Date
Msg-id F78B26BC-B827-43EF-B81D-DC5A10068227@seespotcode.net
Whole thread Raw
In response to Re: Column as arrays.. more efficient than columns?  (Ow Mun Heng <Ow.Mun.Heng@wdc.com>)
Responses Re: Column as arrays.. more efficient than columns?  (Ow Mun Heng <Ow.Mun.Heng@wdc.com>)
List 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



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: log_statement and PREPARE
Next
From: Ow Mun Heng
Date:
Subject: Re: Column as arrays.. more efficient than columns?