Re: char array overhead

From: Steve Atkins <steve(at)blighty(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: char array overhead
Date: 2014-03-31 15:48:01
Message-ID: 748430B7-E4A2-4080-A1F3-8DCE0E969B21@blighty.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Mar 31, 2014, at 8:08 AM, Rob Sargent <robjsargent(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Jungwirth 2014-03-31 15:53:22 Re: Alternative to Multi-Master Replication with 2 Data centers??
Previous Message Tom Lane 2014-03-31 15:28:13 Re: [GENERAL] openvz and shared memory trouble