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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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