Re: [GENERAL] double precision[] storage space questions

2015-06-12 Thread greg
Francisco Olarte wrote > Hi Greg: > > On Fri, Jun 12, 2015 at 4:08 PM, greg < > gregory.jevardat@ > > wrote: >> I cannot find any documentation on the space taken by a double precision >> array. And the few tests I did surprise me. >> >> Here are a few tries I did to understand >> select pg_colu

Re: [GENERAL] double precision[] storage space questions

2015-06-12 Thread Francisco Olarte
Hi Greg: On Fri, Jun 12, 2015 at 4:08 PM, greg wrote: > I cannot find any documentation on the space taken by a double precision > array. And the few tests I did surprise me. > > Here are a few tries I did to understand > select pg_column_size(1.1::double precision) return 8--- a

Re: [GENERAL] double precision[] storage space questions

2015-06-12 Thread Tom Lane
greg writes: > I cannot find any documentation on the space taken by a double precision > array. And the few tests I did surprise me. > Here are a few tries I did to understand > select pg_column_size(1.1::double precision) return 8--- as > expected > select pg_column_size('{}':

[GENERAL] double precision[] storage space questions

2015-06-12 Thread greg
Hi all I cannot find any documentation on the space taken by a double precision array. And the few tests I did surprise me. Here are a few tries I did to understand select pg_column_size(1.1::double precision) return 8--- as expected select pg_column_size('{}'::double precision[