Re: [GENERAL] TOAST not working

["Jim C. Nasby" <jnasby(at)pervasive(dot)com>]

Dropping -general

On Sat, Jun 10, 2006 at 10:58:49PM -0400, Tom Lane wrote:
> "Jim C. Nasby" <jnasby(at)pervasive(dot)com> writes:
> > Actually, it's BLCKSZ/4. From
> > http://www.postgresql.org/docs/8.1/interactive/storage-toast.html:
> 
> > "The TOAST code is triggered only when a row value to be stored in a
> > table is wider than BLCKSZ/4 bytes (normally 2Kb)."
> 
> > BTW, 'row value' seems a bit prone to confusion (could be interpreted as
> > the row itself). It'd probably be better to say 'field'.
> 
> No, because that would be wrong; the statement is correct as written.
> The toaster tries to do something about rows that are wider than
> BLCKSZ/4 (well, actually MaxTupleSize/4 ... try grepping the source
> for TOAST_TUPLE_THRESHOLD).
 
I'll argue that the docs are still confusing though, since 'row value'
could be interpreted as 'field', especially since the first paragraph
contains "In release 7.1 and later, this limit is overcome by allowing
large field values to be compressed and/or broken up into multiple
physical rows."
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby(at)pervasive(dot)com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461