From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
---|---|
To: | "Jeevanandam, Kathirvel (IE10)" <Jeevanandam(dot)Kathirvel(at)honeywell(dot)com> |
Cc: | Tino Wildenhain <tino(at)wildenhain(dot)de>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: triggers, performance Was: Re: [GENERAL] rotate records |
Date: | 2006-03-01 18:48:36 |
Message-ID: | 20060301184836.GH82012@pervasive.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
And what do those functions do? And do their options trigger other
triggers? How about an EXPLAIN ANALYZE from a problem query, too.
On Tue, Feb 28, 2006 at 11:24:34AM +0530, Jeevanandam, Kathirvel (IE10) wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
From | Date | Subject | |
---|---|---|---|
Next Message | Jim C. Nasby | 2006-03-01 18:51:15 | Re: Bad plan on a view |
Previous Message | Robert Treat | 2006-03-01 18:31:44 | Re: Looking for a tool to "*" pg tables as ERDs |