Re: pgsql and large tables - Mailing list pgsql-general

From Doug McNaught
Subject Re: pgsql and large tables
Date
Msg-id m3d72jbikn.fsf@belphigor.mcnaught.org
Whole thread Raw
In response to Re: pgsql and large tables  (Francisco Reyes <lists@natserv.com>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: "Command Prompt, Inc."
Date:
Subject: 7.2 pg_hba.conf load on SIGHUP?
Next
From: "Scott Muir"
Date:
Subject: FW: Vacuuming - how often? (scott's fault?)