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

Re: triggers, performance Was: Re: [GENERAL] rotate records

From: "Jeevanandam, Kathirvel (IE10)" <Jeevanandam(dot)Kathirvel(at)honeywell(dot)com>
To: "Tino Wildenhain" <tino(at)wildenhain(dot)de>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: triggers, performance Was: Re: [GENERAL] rotate records
Date: 2006-02-28 05:54:34
Message-ID: CB23ED848A082748B413D5AE98DDFC3D69FD24@IE10EV801.global.ds.honeywell.com (view raw or flat)
Thread:
Lists: pgsql-performance
I am using triggers for all the events (insert,delete,update) please
find the details below.

trg_delpointtable BEFORE DELETE ON pointtable FOR EACH ROW EXECUTE
PROCEDURE pp_delpointtable()

trg_insdelpoints AFTER DELETE ON pointtable FOR EACH ROW EXECUTE
PROCEDURE pp_insdelpoints()

trgins_pointtable AFTER INSERT ON pointtable FOR EACH ROW EXECUTE
PROCEDURE pp_inspointtable()

trupd_pointtable AFTER UPDATE ON pointtable FOR EACH ROW EXECUTE
PROCEDURE pp_updpointtable()


Basically, this each trigger modifies the content of other dependent
tables.

Best Regards,
Jeeva.K

-----Original Message-----
From: Tino Wildenhain [mailto:tino(at)wildenhain(dot)de] 
Sent: Tuesday, February 28, 2006 10:34 AM
To: Jeevanandam, Kathirvel (IE10)
Cc: pgsql-general(at)postgresql(dot)org
Subject: triggers, performance Was: Re: [GENERAL] rotate records

Jeevanandam, Kathirvel (IE10) schrieb:
> Hi all,
> 
> I am facing performance issues even with less than 3000 records, I am
> using Triggers/SPs in all the tables. What could be the problem.
> Any idea it is good to use triggers w.r.t performance?

Much to general. What triggers? (what are they doing, when are
they invoked...?). Please provide much greater details with
your request or nobody can help.

Regards
Tino

PS: and try not to steal threads

Responses

pgsql-performance by date

Next:From: Javier SomozaDate: 2006-02-28 08:19:36
Subject: Re: fsync and battery-backed caches
Previous:From: Bruno Wolff IIIDate: 2006-02-28 05:08:31
Subject: Re: rotate records

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