Re: pgsql and large tables

"Gurupartap Davis" <partap(at)yahoo(dot)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