From: Terry Lee Tucker <terry@chosen-ones.org>
To: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Subject: Re: question on trigger
Date: Sat, 11 Feb 2012 11:53:15 -0500
Message-ID: <1654881.XedbOmu4no@genesis> (raw)
In-Reply-To: <20120211092244.c760ddbd7c0975bc4b045766db7d895c.249dfd1d7d.wbe@email16.secureserver.net>
References: <20120211092244.c760ddbd7c0975bc4b045766db7d895c.249dfd1d7d.wbe@email16.secureserver.net>
On Saturday, February 11, 2012 09:22:44 AM mgould@isstrucksoftware.net
wrote:
> I will have several triggers which will make sure that the data in some
> columns in in uppercase format. For insert it is a no brainer, however for
> updates, it is better to check and see if the new values is the same and
> only update if different? We are not talking about a huge number of
> transactions. In one day we might have at the most 3000 transactions.
>
> Michael Gould
> Intermodal Software Solutions, LLC
> 904-226-0978
--
Michael:
I am by no means an expert on database performance; however, it seems to me
that you would waste more cycles checking if things changed than simply
forcing upper case for all to which this criteria applies. The whole record is
going to be written to the database anyway.
Terry Lee Tucker
Office: 336-372-6812
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-general@postgresql.org
Cc: terry@chosen-ones.org
Subject: Re: question on trigger
In-Reply-To: <1654881.XedbOmu4no@genesis>
* 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