Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group