X-Original-To: pgsql-general-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 505C79FA159 for ; Sat, 10 Jun 2006 18:41:19 -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 44469-08 for ; Sat, 10 Jun 2006 18:41:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id ADFEC9F9AD3 for ; Sat, 10 Jun 2006 18:41:12 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 8EAA73219B; Sat, 10 Jun 2006 23:41:09 +0200 (MET DST) From: Christopher Browne X-Newsgroups: pgsql.general Subject: Re: TOAST not working Date: Sat, 10 Jun 2006 17:10:06 -0400 Organization: cbbrowne Computing Inc Lines: 15 Message-ID: <87bqt03efl.fsf@wolfe.cbbrowne.com> References: <1149944622.15368.38.camel@vaio1linux> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.19 (linux) Cancel-Lock: sha1:UruhbQc+uYdEPNUuX5JV0hqTD+Q= To: pgsql-general@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/410 X-Sequence-Number: 96782 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. Those are *BIG* numeric values; perhaps you're misunderstanding the intent of TOAST... -- let name="cbbrowne" and tld="gmail.com" in String.concat "@" [name;tld];; http://linuxdatabases.info/info/slony.html What do little birdies see when they get knocked unconscious?