Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] TOAST not working

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Christopher Browne <cbbrowne(at)acm(dot)org>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-docs(at)postgresql(dot)org
Subject: Re: [GENERAL] TOAST not working
Date: 2006-06-11 02:12:15
Message-ID: 20060611021215.GC83625@pervasive.com (view raw or flat)
Thread:
Lists: pgsql-docspgsql-general
On Sat, Jun 10, 2006 at 05:10:06PM -0400, Christopher Browne wrote:
> Centuries ago, Nostradamus foresaw when listman(at)elkenserver(dot)net (list_man) would write:
> > Can someone tell me if I have to 'enable' TOAST on columns to have  it
> > kick in. According to my research, numeric data types are toastable.
> 
> TOAST is only used on individual columns that exceed 8K in size.
> 
> The only way you'll be TOASTing numeric columns is if they are
> individually defined to occupy > 8192 bytes.

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'. Barring
objections, I'll submit a patch.
-- 
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

Responses

pgsql-docs by date

Next:From: Angus BerryDate: 2006-06-11 02:43:02
Subject: Re: TOAST not working
Previous:From: Christopher BrowneDate: 2006-06-10 21:10:06
Subject: Re: TOAST not working

pgsql-general by date

Next:From: Jim C. NasbyDate: 2006-06-11 02:14:40
Subject: Re: are there static variables in pgsql?
Previous:From: Terry Lee TuckerDate: 2006-06-10 22:37:35
Subject: Re: are there static variables in pgsql?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group