X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 43452DB35C for ; Sat, 29 Oct 2005 21:00:07 -0300 (ADT) 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 60260-08 for ; Sun, 30 Oct 2005 00:00:02 +0000 (GMT) Received: from ore.jhcloos.com (ore.jhcloos.com [64.240.156.239]) by svr1.postgresql.org (Postfix) with ESMTP id 07EB7DB34A for ; Sat, 29 Oct 2005 20:59:54 -0300 (ADT) Received: from lugabout.jhcloos.org (host-69-48-15-45.roc.choiceone.net [69.48.15.45]) (using TLSv1 with cipher EDH-RSA-DES-CBC3-SHA (168/168 bits)) (Client CN "lugabout.jhcloos.org", Issuer "ca.jhcloos.com" (verified OK)) by ore.jhcloos.com (Postfix) with ESMTP id D53221C591; Sat, 29 Oct 2005 18:59:54 -0500 (CDT) Received: by lugabout.jhcloos.org (Postfix, from userid 500) id 2FA341D023B; Sat, 29 Oct 2005 23:59:37 +0000 (GMT) From: James Cloos To: Tom Lane Cc: pgsql-sql@postgresql.org Subject: Re: Two tables or three? In-Reply-To: <11826.1130607966@sss.pgh.pa.us> (Tom Lane's message of "Sat, 29 Oct 2005 13:46:06 -0400") References: <11826.1130607966@sss.pgh.pa.us> Copyright: Copyright 2005 James Cloos X-Hashcash: 1:21:051029:tgl@sss.pgh.pa.us::wTe6uds2trpqkGgg:00000000000000000000000000000000000000000000D19s X-Hashcash: 1:21:051029:pgsql-sql@postgresql.org::8FcAAv/yZqR5Foz9:000000000000000000000000000000000000025tF Date: Sat, 29 Oct 2005 19:59:30 -0400 Message-ID: Lines: 11 User-Agent: Gnus/5.110004 (No Gnus v0.4) Emacs/23.0.0 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200510/394 X-Sequence-Number: 23247 >>>>> "Tom" == Tom Lane writes: Tom> You shouldn't contort your schema artificially in order to do that. Tom> Postgres automatically stores wide fields out-of-line ... Cool. Good to know it is even better than I thought. :) -JimC -- James H. Cloos, Jr.