Re: Datatype sizes; a space and speed issue?

From: Joel Matthew <rees(at)ddcom(dot)co(dot)jp>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Datatype sizes; a space and speed issue?
Date: 2004-06-23 05:54:29
Message-ID: 20040623144429.EA3F.REES@ddcom.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> ... the length will be stored first (4 bytes)
> and the actual content following it

Section 8.3 of the manual seems to indicate that the actual character
data is stored in a separate file (background table -- I guess that
might not be a separate file?) for text, unspecified width char, and
char fields which exceed the specified length.

--
Joel Matthew <rees(at)ddcom(dot)co(dot)jp>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-06-23 06:17:13 Re: Datatype sizes; a space and speed issue?
Previous Message Joel Matthew 2004-06-23 05:43:06 Re: Datatype sizes; a space and speed issue?