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 009e01c8e328$bc6d3610$324610ac@ramasubramanian
Whole thread Raw
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: Re: Altering a column type - Most efficient way
Next
From: Mario Weilguni
Date:
Subject: Re: Altering a column type - Most efficient way