From: | Jean-Christophe Boggio <cat(at)thefreecat(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | cmarkiew(at)commnav(dot)com, pgsql-general(at)postgresql(dot)org |
Subject: | Re[2]: TEXT vs VARCHAR |
Date: | 2000-10-10 21:49:36 |
Message-ID: | 5744651919.20001010234936@thefreecat.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello Tom,
On Tuesday, October 10, 2000 à 11:34:49 PM, you said :
TL> "chris markiewicz" <cmarkiew(at)commnav(dot)com> writes:
>> is there a limit on the upper limit of a VARCHAR? i cannot find one in the
>> documentation.
TL> The physical limit is circa 1Gb under TOAST. There's a purely arbitrary
TL> limit at 10Mb, which I put in on the theory that "varchar(100000000)"
TL> is probably a typo and certainly pretty silly. (If anyone wants to
TL> argue that decision, feel free --- I just did it on the spur of the
TL> moment while changing the old code that checked for declared size <
TL> BLCKSZ.)
Excuse me, what is the 8kb-per-record size limit if we can have so
big fields ?
--
Jean-Christophe Boggio
cat(at)thefreecat(dot)org
Independant Consultant and Developer
Delphi, Linux, Oracle, Perl
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-10-10 21:50:25 | Re: Re[2]: TEXT vs VARCHAR |
Previous Message | Vince Vielhaber | 2000-10-10 21:48:59 | Re: Re: [HACKERS] My new job |