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-14 05:59:24
Message-ID: 011701c8e576$c4bcfa80$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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Praveen 2008-07-14 06:34:49 Trigger is not firing immediately
Previous Message Ow Mun Heng 2008-07-14 01:46:46 [SOLVED] Re: Altering a column type - Most efficient way