| From: | Chris <dmagick(at)gmail(dot)com> |
|---|---|
| To: | Praveen <praveen(dot)k(at)renaissance-it(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Trigger is not firing immediately |
| Date: | 2008-07-14 06:52:30 |
| Message-ID: | 487AF7AE.6020606@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Praveen wrote:
>
> 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 ?
Sending the same email over and over again isn't going to get you a
response any quicker.
If you send the details of the trigger and the tables/fields it affects
then you might get a more helpful response.
--
Postgresql & php tutorials
http://www.designmagick.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Praveen | 2008-07-14 07:17:12 | Re: Trigger is not firing immediately |
| Previous Message | A. Kretschmer | 2008-07-14 06:48:00 | Re: Trigger is not firing immediately |