Trigger is taking time to fire

From: "Ramasubramanian" <ramasubramanian(dot)g(at)renaissance-it(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Trigger is taking time to fire
Date: 2008-07-11 07:35:47
Message-ID: 009e01c8e328$bc6d3610$324610ac@ramasubramanian
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi All,
I am having a trigger in table, If i update the the table manually it is not taking time(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).

How can i make the trigger to fire immediately?

Regards,
Ram

Browse pgsql-performance by date

  From Date Subject
Next Message Mario Weilguni 2008-07-11 08:01:08 Re: Altering a column type - Most efficient way
Previous Message Ow Mun Heng 2008-07-11 02:17:00 Re: Altering a column type - Most efficient way