DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	b=RLQoldkGHfhCfgrEXrgc99XRW4KKaE+mWKXohJKKw600CU2xUg+amKbsDTfIZINrzj
	ljJWOoIcsu7pFvKYh/ch2hep75szVmRKRdiZdyy6M+A8Hed28man23n+S1UEPxDKKo+u
	xIDVs97ehTenQlX51qD0lMhodHJtBo5Mw8Wo8=
Message-ID: <487AF7AE.6020606@gmail.com>
Date: Mon, 14 Jul 2008 16:52:30 +1000
From: Chris <dmagick@gmail.com>
User-Agent: Thunderbird 2.0.0.14 (X11/20080505)
MIME-Version: 1.0
To: Praveen <praveen.k@renaissance-it.com>
CC: pgsql-performance@postgresql.org
Subject: Re: Trigger is not firing immediately
References: <001001c8e57b$b72dcf70$274610ac@praveenkm>
In-Reply-To: <001001c8e57b$b72dcf70$274610ac@praveenkm>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Praveen wrote:
>  
> 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 ?

Sending the same email over and over again isn't going to get you a
response any quicker.

If you send the details of the trigger and the tables/fields it affects
then you might get a more helpful response.

-- 
Postgresql & php tutorials
http://www.designmagick.com/