From: Jim C. Nasby <jim@nasby.net>
To: Ruben Rubio <ruben@rentalia.com>
Cc: Heikki Linnakangas <heikki@enterprisedb.com>
Cc: Gregory S. Williamson <gsw@globexplorer.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Optimization of this SQL sentence (SOLVED)
Date: Wed, 18 Oct 2006 14:19:01 -0500
Message-ID: <20061018191901.GO85041@nasby.net> (raw)
In-Reply-To: <4534AFA3.5060102@rentalia.com>
References: <45349CDF.3090002@rentalia.com>
<71E37EF6B7DCC1499CEA0316A256832802B3E738@loki.wc.globexplorer.net>
<4534A35E.9030909@rentalia.com>
<4534A9B2.8060401@enterprisedb.com>
<4534AFA3.5060102@rentalia.com>
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@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jim@nasby.net, ruben@rentalia.com, heikki@enterprisedb.com, gsw@globexplorer.com
Subject: Re: Optimization of this SQL sentence (SOLVED)
In-Reply-To: <20061018191901.GO85041@nasby.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox