E.3.3 Sizes of Array Data Types

The following table lists the sizes of array data types.

Data type	Size (bytes)	Remarks
Array	Length of size portion + 12 + 8 x number of dimensions + data size of each item	If the real data length is less than 127, then the length of the size portion is 1 byte, otherwise it is 4 bytes. Example of estimation when array data is "ARRAY[[1,2,3],[1,2,3]]" Number of dimensions: 2 INTEGER data size: 4 Total size = 1+12+8x2+6x4 = 53

Data type

Size (bytes)

Remarks

Array

Length of size portion + 12 + 8 x number of dimensions + data size of each item

If the real data length is less than 127, then the length of the size portion is 1 byte, otherwise it is 4 bytes.

Example of estimation when array data is "ARRAY[[1,2,3],[1,2,3]]"
Number of dimensions: 2
INTEGER data size: 4
Total size = 1+12+8x2+6x4 = 53