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

Поиск
Список
Период
Сортировка
От Ow Mun Heng
Тема Re: Column as arrays.. more efficient than columns?
Дата
Msg-id 1189126738.17218.10.camel@neuromancer.home.net
обсуждение исходный текст
Ответ на Re: Column as arrays.. more efficient than columns?  (Michael Glaesemann <grzm@seespotcode.net>)
Ответы Re: Column as arrays.. more efficient than columns?  (Michael Glaesemann <grzm@seespotcode.net>)
Список 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 по дате отправления:

Предыдущее
От: Michael Glaesemann
Дата:
Сообщение: Re: Column as arrays.. more efficient than columns?
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Column as arrays.. more efficient than columns?