Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8DCE7650084 for ; Mon, 14 Jul 2008 03:48:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 34617-02 for ; Mon, 14 Jul 2008 03:48:07 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.186]) by postgresql.org (Postfix) with ESMTP id 6867A64FFFC for ; Mon, 14 Jul 2008 03:48:09 -0300 (ADT) Received: from webserv.wug.de ([194.25.154.138]) by mrelayeu.kundenserver.de (node=mrelayeu8) with ESMTP (Nemesis) id 0ML31I-1KIHqs0S65-0000jp; Mon, 14 Jul 2008 08:48:03 +0200 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1KIHqq-0002L9-00 for pgsql-performance@postgresql.org; Mon, 14 Jul 2008 08:48:00 +0200 Date: Mon, 14 Jul 2008 08:48:00 +0200 From: "A. Kretschmer" To: pgsql-performance@postgresql.org Subject: Re: Trigger is not firing immediately Message-ID: <20080714064800.GB5940@a-kretschmer.de> References: <001001c8e57b$b72dcf70$274610ac@praveenkm> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <001001c8e57b$b72dcf70$274610ac@praveenkm> X-OS: Debian/GNU Linux - weil ich es mir Wert bin! User-Agent: Mutt/1.5.9i X-Provags-ID: V01U2FsdGVkX191BpLpF4V3IWbK0VZGR+FZyYdp6RarMcz0+xO eo9gaRYGSaIsi+SVZBgA3cc9SPgEgpVzZomHm+EjL2lXx1xukc qRqZf4z12G0miE47aBtl9RTDltutHWs X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/122 X-Sequence-Number: 30722 am Mon, dem 14.07.2008, um 12:04:49 +0530 mailte Praveen folgendes: > > Hi All, > I am having a trigger in table, If I update the the table manually trigger > is firing immediately(say 200ms per row), But if I update the table through > procedure the trigger is taking time to fire(say 7 to 10 seconds per row). > > Please tell me what kind of changes can I make so that trigger fire > immediately while updating the table through procedure ? Show us more details like source-code of the procedure, the trigger and a demonstration. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net