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 C12D0925C40 for ; Fri, 30 May 2003 12:07:13 -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 30333-06 for ; Fri, 30 May 2003 12:07:12 -0400 (EDT) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by developer.postgresql.org (Postfix) with ESMTP id C98F2925C1A for ; Fri, 30 May 2003 12:07:11 -0400 (EDT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3078866; Fri, 30 May 2003 09:07:16 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: Jeandre du Toit , pgsql-performance@postgresql.org Subject: Re: Table Relationships Date: Fri, 30 May 2003 09:06:43 -0700 User-Agent: KMail/1.4.3 References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200305300906.43044.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/278 X-Sequence-Number: 2057 Jeandre, > instead of normalizing the database. I think that they think that joining > tables will slow down retrieval, is this true? No, it's not. I'm afraid that your co-workers learned their computer knowledge 10 years ago and have not kept up to date. They may need retraining. 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. I highly suggest that you take a look at the book "Database Design for Mere Mortals"; if you're asking the question you posted, you are nowhere near ready to build a production database application. -- Josh Berkus Aglio Database Solutions San Francisco