flattened tables with normalized tables - Mailing list pgsql-general

From Dennis Gearon
Subject flattened tables with normalized tables
Date
Msg-id 416577E3.10804@fireserve.net
Whole thread Raw
Responses Re: flattened tables with normalized tables  (Michael Fuhr <mike@fuhr.org>)
List 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?

pgsql-general by date:

Previous
From: Ron St-Pierre
Date:
Subject: Re: Reading a text file into PostgreSQL
Next
From: Ron St-Pierre
Date:
Subject: Re: [NOVICE] Conditional Relationships?