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

From Ow Mun Heng
Subject Re: Column as arrays.. more efficient than columns?
Date
Msg-id 1189126738.17218.10.camel@neuromancer.home.net
Whole thread Raw
In response to Re: Column as arrays.. more efficient than columns?  (Michael Glaesemann <grzm@seespotcode.net>)
Responses Re: Column as arrays.. more efficient than columns?
List pgsql-general
On Thu, 2007-09-06 at 19:52 -0500, Michael Glaesemann wrote:
> On Sep 6, 2007, at 19:37 , Ow Mun Heng wrote:
>
> > Nobody has any comments on this??
>
> Don't do it.

don't do what?
Don't denormalise the table?
don't put them into arrays?

Thing is, end-result is always for them to be in 1 row and all the
columns are needed for data analysis.

so, it's between a select * from foo vs select avg(...), avg(..) group
by ..



pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Column as arrays.. more efficient than columns?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Column as arrays.. more efficient than columns?