Re: char array overhead - Mailing list pgsql-general

From Steve Atkins
Subject Re: char array overhead
Date
Msg-id 748430B7-E4A2-4080-A1F3-8DCE0E969B21@blighty.com
Whole thread Raw
In response to char array overhead  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: char array overhead
List pgsql-general
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
orto 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,
thereis "char" (with the quotes). 

Cheers,
  Steve



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [ADMIN]openvz and shared memory trouble
Next
From: Paul Jungwirth
Date:
Subject: Re: Alternative to Multi-Master Replication with 2 Data centers??