Re: sql question (hopefully) - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: sql question (hopefully)
Date
Msg-id 20030618143744.GC20256@wolff.to
Whole thread Raw
In response to Re: sql question (hopefully)  ("Mel Jamero" <mel@gmanmi.tv>)
List pgsql-novice
On Wed, Jun 18, 2003 at 22:40:49 +0800,
  Mel Jamero <mel@gmanmi.tv> wrote:
>
> The reason why I didn't normalize was because i would've ended up with
> millions of tuples and the reply from the database would be too slow for the
> application(s) we built.  I tried to come up with a better schema but I
> couldn't find one that really returns a fast reply so I settled with the one
> i presented.
>
> I did break other rules of proper Relational Analysis and Design for the
> sake of fast replies we needed.  I'll send it to this list in the future to
> get better ideas.  I just have to solve our current problem.

Did you actually test both the normalized and denormalized versions to see
which is faster?

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: help:steps needed to get the content of table from the
Next
From: Josh Berkus
Date:
Subject: Re: sql question (hopefully)