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
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
In response to
pgsql-docs by date
|Next:||From: Martijn van Oosterhout||Date: 2006-06-12 10:07:03|
|Subject: Re: TOAST not working|
|Previous:||From: Tom Lane||Date: 2006-06-11 02:58:49|
|Subject: Re: [GENERAL] TOAST not working |
pgsql-general by date
|Next:||From: Alex Turner||Date: 2006-06-11 04:27:33|
|Subject: Re: Problems with database bloat|
|Previous:||From: Tom Lane||Date: 2006-06-11 03:14:00|
|Subject: Re: [GENERAL] Error Starting Back END |