space taken by NULL values in array

From: Leonardo Francalanci <m_lists(at)yahoo(dot)it>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: space taken by NULL values in array
Date: 2010-09-20 07:58:45
Message-ID: 945693.66269.qm@web29016.mail.ird.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yaroslav Tykhiy 2010-09-20 08:08:38 Re: Query plan choice issue
Previous Message Tatsuo Ishii 2010-09-20 04:31:35 Re: pgpool-II 3.0 + postgres 9rc1 + md5 authentication not working