| From: | "Jim C(dot) Nasby" <jim(at)nasby(dot)net> |
|---|---|
| To: | Ruben Rubio <ruben(at)rentalia(dot)com> |
| Cc: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, "Gregory S(dot) Williamson" <gsw(at)globexplorer(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Optimization of this SQL sentence (SOLVED) |
| Date: | 2006-10-18 19:19:01 |
| Message-ID: | 20061018191901.GO85041@nasby.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, Oct 17, 2006 at 12:25:39PM +0200, Ruben Rubio wrote:
> First of all I have to say that I now the database is not ok. There was
> a people before me that didn't do the thinks right. I would like to
> normalize the database, but it takes too much time (there is is hundred
> of SQLs to change and there is not enough technical resources). Also,
> datacolumns in some places has same names, but the data that is stores
> has different usages.
FWIW, things like views and rules make those transations a lot easier to
tackle.
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2006-10-18 19:37:07 | Re: Optimization of this SQL sentence |
| Previous Message | Jim C. Nasby | 2006-10-18 19:17:34 | Re: Optimization of this SQL sentence |