X-Original-To: pgsql-docs-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 247659FA2A0; Sat, 10 Jun 2006 23:12:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 49599-02; Sat, 10 Jun 2006 23:12:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 861159F9AD3; Sat, 10 Jun 2006 23:12:21 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 4326C5648D; Sat, 10 Jun 2006 21:12:19 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Sat, 10 Jun 2006 21:12:15 -0500 Date: Sat, 10 Jun 2006 21:12:15 -0500 From: "Jim C. Nasby" To: Christopher Browne Cc: pgsql-general@postgresql.org, pgsql-docs@postgresql.org Subject: Re: [GENERAL] TOAST not working Message-ID: <20060611021215.GC83625@pervasive.com> References: <1149944622.15368.38.camel@vaio1linux> <87bqt03efl.fsf@wolfe.cbbrowne.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <87bqt03efl.fsf@wolfe.cbbrowne.com> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060611:cbbrowne@acm.org::PDAUruoDxttLhcT6:0BAnY X-Hashcash: 1:20:060611:pgsql-general@postgresql.org::0Y51ma8d37kiXYVh:000000000 000000000000000000000000SvwK X-Hashcash: 1:20:060611:pgsql-docs@postgresql.org::zalwfnI5xEJxjo4U:000000000000 00000000000000000000000032qd X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/2 X-Sequence-Number: 3585 On Sat, Jun 10, 2006 at 05:10:06PM -0400, Christopher Browne wrote: > Centuries ago, Nostradamus foresaw when listman@elkenserver.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@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461