Skip site navigation (1) Skip section navigation (2)

Re: Table Relationships

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Jeandre du Toit <jeandre(at)itvs(dot)co(dot)za>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Table Relationships
Date: 2003-05-30 12:11:01
Message-ID: 20030530121101.GA8920@wolff.to (view raw or flat)
Thread:
Lists: pgsql-performance
On Fri, May 30, 2003 at 11:23:10 +0200,
  Jeandre du Toit <jeandre(at)itvs(dot)co(dot)za> 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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

In response to

Responses

pgsql-performance by date

Next:From: Bruno Wolff IIIDate: 2003-05-30 12:13:11
Subject: Re: Select query takes long to execute
Previous:From: Victor YegorovDate: 2003-05-30 10:10:09
Subject: Re: Table Relationships

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group