X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BFC5652A50 for ; Sat, 5 Mar 2005 04:33:58 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 12324-06 for ; Sat, 5 Mar 2005 04:33:49 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id D574054C94 for ; Sat, 5 Mar 2005 04:33:48 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j254XgIp013976; Fri, 4 Mar 2005 23:33:42 -0500 (EST) To: "Dave Held" Cc: pgsql-performance@postgresql.org Subject: Re: MAIN vs. PLAIN In-reply-to: <49E94D0CFCD4DB43AFBA928DDD20C8F902618465@asg002.asg.local> References: <49E94D0CFCD4DB43AFBA928DDD20C8F902618465@asg002.asg.local> Comments: In-reply-to "Dave Held" message dated "Fri, 04 Mar 2005 14:59:01 -0600" Date: Fri, 04 Mar 2005 23:33:42 -0500 Message-ID: <13975.1109997222@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/86 X-Sequence-Number: 10791 "Dave Held" writes: > I notice that by default, postgres sets numeric fields to > storage MAIN. What exactly does that mean? See http://developer.postgresql.org/docs/postgres/storage-toast.html There isn't any amazingly strong reason why numeric defaults to MAIN rather than EXTENDED, which is the default for every other toastable datatype --- except that I thought it'd be a good idea to have at least one type that did so, just to exercise that code path in the tuple toaster. And numeric shouldn't ordinarily be large enough to need out-of-line storage anyway. It's unlikely even to need compression, really, but as long as it's a varlena type the overhead to support toasting is nearly nil. regards, tom lane