Postgres Pro
Downloads
Home   >   mailing lists

Trigger is taking time to fire - Mailing list pgsql-performance

From Ramasubramanian
Subject Trigger is taking time to fire
Date
Msg-id 011701c8e576$c4bcfa80$324610ac@ramasubramanian
Whole thread Raw
Responses Re: Trigger is taking time to fire
List pgsql-performance
Tree view
 

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

pgsql-performance by date:

Previous
From: Ow Mun Heng
Date:
Subject: [SOLVED] Re: Altering a column type - Most efficient way
Next
From: "Praveen"
Date:
Subject: Trigger is not firing immediately