Skip site navigation (1) Skip section navigation (2)

Trigger is not firing immediately

From: "Praveen" <praveen(dot)k(at)renaissance-it(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Trigger is not firing immediately
Date: 2008-07-14 06:34:49
Message-ID: 001001c8e57b$b72dcf70$274610ac@praveenkm (view raw or flat)
Thread:
Lists: pgsql-performance
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

Responses

pgsql-performance by date

Next:From: A. KretschmerDate: 2008-07-14 06:48:00
Subject: Re: Trigger is not firing immediately
Previous:From: RamasubramanianDate: 2008-07-14 05:59:24
Subject: Trigger is taking time to fire

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group