I am using pg 7.4.1 and have created a trigger over table with 3 M rows.
If I start masive update on this table, pg executes this trigger on
every row and dramaticaly slows the system.
Exists in pg any way to define the trigger execution only if I have
changes on some fields?
For example I am able to declare this in oracle.
My trigger is writen in pgSQL.
pgsql-performance by date
|Next:||From: Syd||Date: 2004-01-15 13:56:36|
|Subject: insert speed - Mac OSX vs Redhat|
|Previous:||From: Andrew McMillan||Date: 2004-01-15 02:57:08|
|Subject: Re: 100 simultaneous connections, critical limit?|