Trigger question - Mailing list pgsql-performance

From pginfo
Subject Trigger question
Date
Msg-id 400691EA.96598C34@t1.unisoftbg.com
Whole thread Raw
Responses Re: Trigger question
List pgsql-performance
Hi,

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.

regards,
ivan.


pgsql-performance by date:

Previous
From: "Matt Clark"
Date:
Subject: Re: insert speed - Mac OSX vs Redhat
Next
From: Tom Lane
Date:
Subject: Re: insert speed - Mac OSX vs Redhat