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 AFCBC924C1B for ; Fri, 30 May 2003 08:10:03 -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 75671-09 for ; Fri, 30 May 2003 08:09:08 -0400 (EDT) Received: from wolff.to (wolff.to [66.93.249.74]) by developer.postgresql.org (Postfix) with SMTP id AA92B924B30 for ; Fri, 30 May 2003 08:08:56 -0400 (EDT) Received: (qmail 8953 invoked by uid 500); 30 May 2003 12:11:01 -0000 Date: Fri, 30 May 2003 07:11:01 -0500 From: Bruno Wolff III To: Jeandre du Toit Cc: pgsql-performance@postgresql.org Subject: Re: Table Relationships Message-ID: <20030530121101.GA8920@wolff.to> Mail-Followup-To: Jeandre du Toit , pgsql-performance@postgresql.org References: <001c01c32689$82da1050$0403a8c0@fejleszt4> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/272 X-Sequence-Number: 2051 On Fri, May 30, 2003 at 11:23:10 +0200, Jeandre du Toit wrote: > Don't reply to existing threads to start a new thread. > What are the advantages to having a database relational? I am currently > discussing the design of a database with some people at work and they > reckon it is best to create one table with and index and all the data > instead of normalizing the database. I think that they think that joining > tables will slow down retrieval, is this true? You might want to read some books on relational database theory. Date and Pascal are two noted authors of books on relational database theory. > > Thanks > Jeandre > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly