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.
>