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 ?
pgsql-performance by date
|Next:||From: A. Kretschmer||Date: 2008-07-14 06:48:00|
|Subject: Re: Trigger is not firing immediately|
|Previous:||From: Ramasubramanian||Date: 2008-07-14 05:59:24|
|Subject: Trigger is taking time to fire|