"Jim C. Nasby" <jnasby@xxxxxxxxxxxxx> writes: > On Thu, Jun 08, 2006 at 11:18:02AM +0200, Ludek Finstrle wrote: >> I read this value in TOAST section. Is my opinion correct? > From http://www.postgresql.org/docs/8.1/interactive/storage-toast.html: > "TOAST usurps the high-order two bits of the varlena length word, > thereby limiting the logical size of any value of a TOAST-able data type > to 1Gb (2^30 - 1 bytes)." > There was a proposal made some time ago to allow for a variable-length > length word format, where one of the bits in each word would specify > that there was an additional length word. Hm, I don't remember that. It seems rather pointless, as I'm quite sure that the *practical* limit is a great deal less than 1Gb. Has anyone done any performance testing of GB-sized toasted values? regards, tom lane
