Trigger question

From: pginfo <pginfo(at)t1(dot)unisoftbg(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Trigger question
Date: 2004-01-15 13:13:15
Message-ID: 400691EA.96598C34@t1.unisoftbg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Syd 2004-01-15 13:56:36 insert speed - Mac OSX vs Redhat
Previous Message Andrew McMillan 2004-01-15 02:57:08 Re: 100 simultaneous connections, critical limit?