Jean-Christophe Boggio <cat(at)thefreecat(dot)org> 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.
> Excuse me, what is the 8kb-per-record size limit if we can have so
> big fields ?
Sorry --- TOAST is 7.1. In existing releases, TEXT, VARCHAR, and CHAR
are all constrained by the BLCKSZ limit on total row size. But still,
that offers no reason for choosing TEXT over VARCHAR or vice versa.
regards, tom lane