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

Re: Trigger is not firing immediately

From: Chris <dmagick(at)gmail(dot)com>
To: Praveen <praveen(dot)k(at)renaissance-it(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Trigger is not firing immediately
Date: 2008-07-14 06:52:30
Message-ID: 487AF7AE.6020606@gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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/

In response to

pgsql-performance by date

Next:From: PraveenDate: 2008-07-14 07:17:12
Subject: Re: Trigger is not firing immediately
Previous:From: A. KretschmerDate: 2008-07-14 06:48:00
Subject: Re: Trigger is not firing immediately

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