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 276CE9FA60C for ; Sat, 10 Jun 2006 14:40: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 04064-02 for ; Sat, 10 Jun 2006 14:40:13 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.elkenserver.net (unknown [63.236.47.51]) by postgresql.org (Postfix) with ESMTP id 0A9C29F9AD3 for ; Sat, 10 Jun 2006 14:40:11 -0300 (ADT) Received: (qmail 3186 invoked by uid 507); 10 Jun 2006 13:03:20 -0400 Received: from localhost (HELO svn.elkenserver.net) (127.0.0.1) by mail.elkenserver.net with SMTP; 10 Jun 2006 13:03:20 -0400 Subject: Re: TOAST not working From: list_man Reply-To: listman@elkenserver.net To: Tom Lane Cc: pgsql-general@postgresql.org In-Reply-To: <664.1149956898@sss.pgh.pa.us> References: <1149944622.15368.38.camel@vaio1linux> <664.1149956898@sss.pgh.pa.us> Content-Type: text/plain Date: Sat, 10 Jun 2006 13:15:15 -0400 Message-Id: <1149959715.15368.47.camel@vaio1linux> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 (2.0.4-7) Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/396 X-Sequence-Number: 96768 Thanks for the suggestion Tom... I'm looking into it. To continue however and educate me on datatypes & TOAST, should a row of 10k+, in this case consisting of the datatype listed below, store OK, when TOAST kicks in? thanks... Angus On Sat, 2006-06-10 at 12:28 -0400, Tom Lane wrote: > list_man writes: > > I have a VERY wide table and rows. There are over 800 columns of type: > > numeric(11,2) > > Perhaps you should reconsider your data design. Maybe some of those > columns would more logically form an array? > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend >