Re: fixed size columns

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: elein(at)varlena(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: fixed size columns
Date: 2003-05-02 10:34:54
Message-ID: ubi4bv0s7bvve8e7no6anmfcl6200mvr0b@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 30 Apr 2003 12:28:27 -0700, elein <elein(at)sbcglobal(dot)net> wrote:
>But are the fixed size varchars and characters
>being stored as varlenas with a 4byte overhead
>[...]?

Yes. One of the reasons for this is that a fixed number of characters
does not necessarily mean a fixed number of bytes.

Servus
Manfred

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-05-02 13:33:43 Re: Slow Queries with OR's?
Previous Message Mr Mat psql-mail 2003-05-02 08:54:19 Re: Slow Queries with OR's?