Обсуждение: wrong information about unlimied size of text field?

hi
according to what i know, where is a limit for up to 2gigabytes of data
in text fields (according to c.h).
this limit is of course very big, but i belive it should be mentioned in
datatype.sgml instead of saying:

<entry><type>text</type></entry>
<entry>Variable unlimited length</entry>

if this is not the case, i'd like some information how longer text's can
be stored, when text is internally of "varlena" type, where
varlena.vl_len is of int32 type.

best regards

depesz

--
hubert depesz lubaczewski                          http://www.depesz.pl/
------------------------------------------------------------------------
Mój Boże, spraw abym milczał, dopóki się nie upewnię,  że  naprawdę  mam
coś do powiedzenia.                                      (c) 1998 depesz

Hubert depesz Lubaczewski writes:

> according to what i know, where is a limit for up to 2gigabytes of data
> in text fields (according to c.h).
> this limit is of course very big, but i belive it should be mentioned in
> datatype.sgml instead of saying:

If you continue reading you will find

    The storage requirement for data of these types is 4 bytes plus
    the actual string, and in case of <type>character</type> plus the
    padding.  Long strings will be compressed by the system
    automatically, so the physical requirement on disk may be less.
    In any case, the longest possible character string
    that can be stored is about 1 GB.  (The maximum value that will be
    allowed for <replaceable>n</> in the data type declaration is
    less than that.  It wouldn't be very useful to change
    this because with multibyte character encodings the number of
    characters and bytes can be quite different anyway.  If you desire
    to store long strings with no specific upper limit, use <type>text</type>
    or <type>character varying</type> without a length specifier,
    rather than making up an arbitrary length limit.)

which seems to be the information you are looking for.

--
Peter Eisentraut   peter_e@gmx.net

Current FAQ on web site lists limit as 1GB.  I think I fixed that only recently.

---------------------------------------------------------------------------

Hubert depesz Lubaczewski wrote:
-- Start of PGP signed section.
> hi
> according to what i know, where is a limit for up to 2gigabytes of data
> in text fields (according to c.h).
> this limit is of course very big, but i belive it should be mentioned in
> datatype.sgml instead of saying:
>
> <entry><type>text</type></entry>
> <entry>Variable unlimited length</entry>
>
> if this is not the case, i'd like some information how longer text's can
> be stored, when text is internally of "varlena" type, where
> varlena.vl_len is of int32 type.
>
> best regards
>
> depesz
>
> --
> hubert depesz lubaczewski                          http://www.depesz.pl/
> ------------------------------------------------------------------------
> M?j Bo?e, spraw abym milcza?, dop?ki si? nie upewni?,  ?e  naprawd?  mam
> co? do powiedzenia.                                      (c) 1998 depesz
>
-- End of PGP section, PGP failed!

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

On Tue, Sep 03, 2002 at 08:55:37PM +0200, Peter Eisentraut wrote:
> > according to what i know, where is a limit for up to 2gigabytes of data
> > in text fields (according to c.h).
> > this limit is of course very big, but i belive it should be mentioned in
> > datatype.sgml instead of saying:
> If you continue reading you will find
> which seems to be the information you are looking for.

o.k. now i know it for sure. but what about others who just stumble on
"unlimited length", and just *dont* read further? why put such a false
statement in our docs?

depesz

--
hubert depesz lubaczewski                          http://www.depesz.pl/
------------------------------------------------------------------------
Mój Boże, spraw abym milczał, dopóki się nie upewnię,  że  naprawdę  mam
coś do powiedzenia.                                      (c) 1998 depesz