array behavior - Mailing list pgsql-hackers

From amit sehas
Subject array behavior
Date
Msg-id 1323987353.93002.YahooMailClassic@web160504.mail.bf1.yahoo.com
Whole thread Raw
Responses Re: array behavior  (Marti Raudsepp <marti@juffo.org>)
List 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 by date:

Previous
From: amit sehas
Date:
Subject: Cursor behavior
Next
From: Noah Misch
Date:
Subject: Re: Measuring relation free space