Re: [GENERAL] char array overhead

2014-03-31 Thread Alvaro Herrera
Rob Sargent wrote: > Jsyk, I'm toying with a rather large number of small valued > datapoints per sample. I'm tying text and smallint as well. You could try "char"[] ... -- Álvaro Herrerahttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services --

Re: [GENERAL] char array overhead

2014-03-31 Thread Rob Sargent
On 03/31/2014 09:48 AM, Steve Atkins wrote: On Mar 31, 2014, at 8:08 AM, Rob Sargent wrote: I'm angling toward using a very wide char(1) array. Is the one-byte overhead for char(n<126) applied to each element or to the array? Each element, it's a variable length type. There's probably a be

Re: [GENERAL] char array overhead

2014-03-31 Thread Steve Atkins
On Mar 31, 2014, at 8:08 AM, Rob Sargent wrote: > I'm angling toward using a very wide char(1) array. Is the one-byte overhead > for char(n<126) applied to each element or to the array? Each element, it's a variable length type. There's probably a better way of storing your data, but if you

[GENERAL] char array overhead

2014-03-31 Thread Rob Sargent
I'm angling toward using a very wide char(1) array. Is the one-byte overhead for char(n<126) applied to each element or to the array?