Postgres Pro
Downloads
Home   >   mailing lists

Trigger is not firing immediately - Mailing list pgsql-performance

From Praveen
Subject Trigger is not firing immediately
Date
Msg-id 001001c8e57b$b72dcf70$274610ac@praveenkm
Whole thread Raw
Responses Re: Trigger is not firing immediately
Re: Trigger is not firing immediately
List pgsql-performance
Tree view
 
Hi All,
    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 ?
 
Regards,
Praveen

pgsql-performance by date:

Previous
From: "Ramasubramanian"
Date:
Subject: Trigger is taking time to fire
Next
From: "A. Kretschmer"
Date:
Subject: Re: Trigger is not firing immediately