> No, that's just a coincidence. The reason that TOAST limits fields to
> 1Gb is that the high-order two bits of the varlena length word were
> commandeered as TOAST state indicators. There are now only thirty bits
> available to represent the length of a variable-length Datum; hence the
> hard limit on field width is 1Gb.
>
> I'd think that the "practical" limit is quite a bit less than that, at
> least until we devise an API that lets you read and write toasted values
> in sections.
Yes, passing around multi-gigabytes memory chunks in a process is pretty
slow.
--
Bruce Momjian | http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
