X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id DC0139DC9E4 for ; Wed, 1 Mar 2006 14:48:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 62944-07 for ; Wed, 1 Mar 2006 14:48:38 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id AB3329DC9AE for ; Wed, 1 Mar 2006 14:48:36 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id 2AC3756457; Wed, 1 Mar 2006 12:48:37 -0600 (CST) Received: (hashcash-sendmail, from uid 1001); Wed, 1 Mar 2006 12:48:36 -0600 Date: Wed, 1 Mar 2006 12:48:36 -0600 From: "Jim C. Nasby" To: "Jeevanandam, Kathirvel (IE10)" Cc: Tino Wildenhain , pgsql-performance@postgresql.org Subject: Re: triggers, performance Was: Re: [GENERAL] rotate records Message-ID: <20060301184836.GH82012@pervasive.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060301:jeevanandam.kathirvel@honeywell.com::wgj+A5WO90fWDFxU:00 00000000000000000000000002ri X-Hashcash: 1:20:060301:tino@wildenhain.de::xdd2v3a+CupWHUso:0000000000000000000 0000000000000000000000004LNS X-Hashcash: 1:20:060301:pgsql-performance@postgresql.org::0lO7U2oveDENgMC6:00000 0000000000000000000000002bAr X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.109 required=5 tests=[AWL=0.109] X-Spam-Score: 0.109 X-Spam-Level: X-Archive-Number: 200603/11 X-Sequence-Number: 17448 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@wildenhain.de] > Sent: Tuesday, February 28, 2006 10:34 AM > To: Jeevanandam, Kathirvel (IE10) > Cc: pgsql-general@postgresql.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@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461