Re: pgsql and large tables

"Gurupartap Davis" <partap@yahoo.com> writes:

> Sheesh...I think I see what you're saying about normalization.  I've never
> had a formal db class, but it looks like you're talking about removing all
> the redundancy from the database...and there's a lot in this one(!)

[...]

> Dang...I don't know if my employer will let me make a change this radical,
> though.  We would have to redo every single query in about 50 scripts.

You might be able to define views and rules in such a way that old
queries still work, or work with minor changes.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863