Re: Toast, Text, blob bytea Huh?

> 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