Postgres Pro
Downloads
Home   >   mailing lists

space taken by NULL values in array - Mailing list pgsql-general

From Leonardo Francalanci
Subject space taken by NULL values in array
Date
Msg-id 945693.66269.qm@web29016.mail.ird.yahoo.com
Whole thread Raw
Responses Re: space taken by NULL values in array  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view 
Hi,


since postgresql multidimensional arrays can't have different size per axis, I
was wondering what would happen in case I used an array of, say, 10x10
elements, where only 10x2 elements are filled and the rest are NULL. I guess
the NULL elements take space (and I would have 80% of the space wasted),
but I'm not sure...

Can someone confirm?

pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: pgpool-II 3.0 + postgres 9rc1 + md5 authentication not working
Next
From: Yaroslav Tykhiy
Date:
Subject: Re: Query plan choice issue