flattened tables with normalized tables

From: Dennis Gearon <gearond(at)fireserve(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: flattened tables with normalized tables
Date: 2004-10-07 17:07:47
Message-ID: 416577E3.10804@fireserve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

If I want to set up a dbase with normalized tables for inserts,and a
flattened table for selects, am i going in the right direction for
speeding up a busy site?

Also, if some of you are also doing this, how and how often do you do
the SELECT from the normalized tables to the flattened table?
And, do you have to write a post trigger to get all the references to
match up in the flattened table?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron St-Pierre 2004-10-07 17:10:55 Re: [NOVICE] Conditional Relationships?
Previous Message Ron St-Pierre 2004-10-07 17:02:03 Re: Reading a text file into PostgreSQL