Re: Reducing the overhead of NUMERIC data - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Reducing the overhead of NUMERIC data
Date
Msg-id 20051103141358.GA6622@surnet.cl
Whole thread Raw
In response to Re: Reducing the overhead of NUMERIC data  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Reducing the overhead of NUMERIC data
List pgsql-hackers
Simon Riggs wrote:

> On PostgreSQL, CHAR(12) is a bpchar datatype with all instantiations of
> that datatype having a 4 byte varlena header. In this example, all of
> those instantiations having the varlena header set to 12, so essentially
> wasting the 4 byte header.

We need the length word because the actual size in bytes is variable,
due to multibyte encoding considerations.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Reducing the overhead of NUMERIC data
Next
From: Simon Riggs
Date:
Subject: Re: Reducing the overhead of NUMERIC data