Re: char array overhead - Mailing list pgsql-general

From Rob Sargent
Subject Re: char array overhead
Date
Msg-id 5339A167.9000006@gmail.com
Whole thread Raw
In response to Re: char array overhead  (Steve Atkins <steve@blighty.com>)
Responses Re: char array overhead  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-general
On 03/31/2014 09:48 AM, Steve Atkins wrote:
On Mar 31, 2014, at 8:08 AM, Rob Sargent <robjsargent@gmail.com> 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 end up really needing a one-byte long character type, there is "char" (with the quotes).

Cheers, Steve



Thank you! First for the confirmation on the overhead (how disappointing) and secondly for the "char".  That had not crossed my radar.

Jsyk, I'm toying with a rather large number of small valued datapoints per sample.  I'm tying text and smallint as well.

Thanks again,

rjs

pgsql-general by date:

Previous
From: Paul Jungwirth
Date:
Subject: Re: Alternative to Multi-Master Replication with 2 Data centers??
Next
From: Leonardo M. Ramé
Date:
Subject: Complex query