From: Chris <dmagick@gmail.com>
To: Praveen <praveen.k@renaissance-it.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Trigger is not firing immediately
Date: Mon, 14 Jul 2008 16:52:30 +1000
Message-ID: <487AF7AE.6020606@gmail.com> (raw)
In-Reply-To: <001001c8e57b$b72dcf70$274610ac@praveenkm>
References: <001001c8e57b$b72dcf70$274610ac@praveenkm>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dmagick@gmail.com, praveen.k@renaissance-it.com
Subject: Re: Trigger is not firing immediately
In-Reply-To: <487AF7AE.6020606@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox