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

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: log_statement and PREPARE
Следующее
От: Ow Mun Heng
Дата:
Сообщение: Re: Column as arrays.. more efficient than columns?