> 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 pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026