Skip site navigation (1) Skip section navigation (2)

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: (view raw or whole thread)
Lists: pgsql-performance

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: SydDate: 2004-01-15 13:56:36
Subject: insert speed - Mac OSX vs Redhat
Previous:From: Andrew McMillanDate: 2004-01-15 02:57:08
Subject: Re: 100 simultaneous connections, critical limit?

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group