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: 400691EA.96598C34@t1.unisoftbg.com (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group