array behavior

Поиск
Список
Период
Сортировка
От amit sehas
Тема array behavior
Дата
Msg-id 1323987353.93002.YahooMailClassic@web160504.mail.bf1.yahoo.com
обсуждение исходный текст
Ответы Re: array behavior  (Marti Raudsepp <marti@juffo.org>)
Список pgsql-hackers
If a field(attribute) in a type is declared to be an array. Then is it always the case that the array will be packed
intoa single tuple that resides in the database. There is the TOAST mechanism for oversized tuples but that is still
consideredto be a single tuple. Is there any circumstance in which an attribute which is an array will be broken up
intoindividual
 
tuples which are somehow associated with the main tuple. Such as if the array happens to have 5000 elements and the
tuplewill become quite large if these are packed within a single tuple and additionally it may have undesirable
performanceimpact if the queries are not even interested in seeing the array when fetching the object ?
 

thanks


В списке pgsql-hackers по дате отправления:

Предыдущее
От: amit sehas
Дата:
Сообщение: Cursor behavior
Следующее
От: Noah Misch
Дата:
Сообщение: Re: Measuring relation free space