Re: Datatype sizes; a space and speed issue? - Mailing list pgsql-general

From Joel Matthew
Subject Re: Datatype sizes; a space and speed issue?
Date
Msg-id 20040623144429.EA3F.REES@ddcom.co.jp
Whole thread Raw
In response to Re: Datatype sizes; a space and speed issue?  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Responses Re: Datatype sizes; a space and speed issue?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@ddcom.co.jp>


pgsql-general by date:

Previous
From: Joel Matthew
Date:
Subject: Re: Datatype sizes; a space and speed issue?
Next
From: Tom Lane
Date:
Subject: Re: Datatype sizes; a space and speed issue?