X-Original-To: pgsql-performance@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id EBB56925C5D for ; Fri, 30 May 2003 12:39:02 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 37704-06 for ; Fri, 30 May 2003 12:39:02 -0400 (EDT) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by developer.postgresql.org (Postfix) with ESMTP id ED1F6925C54 for ; Fri, 30 May 2003 12:39:01 -0400 (EDT) Received: from [10.1.2.130] (helo=dba2) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 19LmuD-0002sa-00 for ; Fri, 30 May 2003 12:39:01 -0400 Received: by dba2 (Postfix, from userid 1019) id D4526D1BB; Fri, 30 May 2003 12:39:00 -0400 (EDT) Date: Fri, 30 May 2003 12:39:00 -0400 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Table Relationships Message-ID: <20030530163900.GF18140@libertyrms.info> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <200305300906.43044.josh@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200305300906.43044.josh@agliodbs.com> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/281 X-Sequence-Number: 2060 On Fri, May 30, 2003 at 09:06:43AM -0700, Josh Berkus wrote: > Modern database systems, especially PostgreSQL, are much faster with a proper > relational schema than with an inadequate flat-file table, due to the > efficient storage of data ... i.e., no redundancy. Are you sure you want to say it that strongly? After all, if you have a data set which needs always to be returned in the same static format, why not just denormalise it? It's sure faster that way in every system I've ever encountered. It's only when you actually have relations to cope with that it ceases to be an advantage. So, as usual, it depends on what you're trying to do. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110