From: Jackson, DeJuan <djackson@cpsgroup.com>
To: Guido.Goldstein@t-online.de, pgsql-sql@hub.org, Gregory Holston <holston@itd.nrl.navy.mil>
Subject: RE: [SQL] Text type
Date: Wed, 13 Jan 1999 17:38:00 -0600
Message-ID: <F10BB1FAF801D111829B0060971D839F5DC74E@cpsmail> (raw)
The current limit to a TEXT field is MAX_TUPLE_SIZE - TUPLE_OVERHEAD -
ANY_OTHER_FIELD_SIZES_AND_OVERHEAD, which with no other fields in the
table is just less than 8k. But this can be increased at compile time.
It's set to 8k because that tends to be optimal page size for most of
the OS's that are supported.
-DEJ
> -----Original Message-----
> From: Guido.Goldstein@t-online.de [mailto:Guido.Goldstein@t-online.de]
> Sent: Wednesday, January 13, 1999 7:40 AM
> To: pgsql-sql@hub.org
> Subject: Re: [SQL] Text type
>
>
>
> Hello!
>
> On Wed, 13 Jan 1999 08:56:19 +0100 (MET)
> Remigiusz Sokolowski <rems@gdansk.sprint.pl> wrote:
> > >
> > > Hi List,
> > >
> > > What is the max size of the text type in characters,
> preferable, or
> > > bytes.
> > >
> > > Thanks,
> > >
> > > -Greg
> >
> > AFAIK this is 8KB
>
> Somewhat less then 8K, because one -record- has to fit into one page
> (of 8K). AFAIK.
>
> Bye
> Guido
> --
> We're showing progress. Things are getting worse at a slower rate.
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: djackson@cpsgroup.com, holston@itd.nrl.navy.mil
Subject: Re: [SQL] Text type
In-Reply-To: <F10BB1FAF801D111829B0060971D839F5DC74E@cpsmail>
References: <F10BB1FAF801D111829B0060971D839F5DC74E@cpsmail>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox