Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id AF3702E004D for ; Sun, 27 Apr 2008 10:02:50 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 37332-01-9 for ; Sun, 27 Apr 2008 10:02:45 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from vms173003pub.verizon.net (vms173003pub.verizon.net [206.46.173.3]) by developer.postgresql.org (Postfix) with ESMTP id 518AE2E0030 for ; Sun, 27 Apr 2008 10:01:20 -0300 (ADT) Received: from [192.168.0.251] ([96.242.5.78]) by vms173003.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0JZZ00IOWIP7VCW4@vms173003.mailsrvcs.net> for pgsql-sql@postgresql.org; Sun, 27 Apr 2008 07:58:20 -0500 (CDT) Date: Sun, 27 Apr 2008 09:01:11 -0400 From: Jean-David Beyer Subject: Curious about wide tables. To: pgsql-sql@postgresql.org Message-id: <48147917.8000108@verizon.net> Organization: Institute for Regimented Whimsey MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: 7bit X-Enigmail-Version: 0.94.0.0 User-Agent: Thunderbird 1.5.0.9 (X11/20070317) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200804/199 X-Sequence-Number: 30738 In another thread, the O.P. had a question about a large table with over 100 columns. Is this usual? Whenever I make a database, which is not often, it ends up with tables that rarely have over to columns, and usually less than that. When normalized, my tables rarely get very wide. Without criticising the O.P., since I know nothing about his application, I am curious how it comes about that such a wide table is justified. -- .~. Jean-David Beyer Registered Linux User 85642. /V\ PGP-Key: 9A2FC99A Registered Machine 241939. /( )\ Shrewsbury, New Jersey http://counter.li.org ^^-^^ 08:55:01 up 40 days, 13:57, 2 users, load average: 4.32, 4.27, 4.18