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
am Mon, dem 14.07.2008, um 12:04:49 +0530 mailte Praveen folgendes:
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
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
Hi all,
Please find the procedure and trigger which took more time when we try
to update value in table through Procedure.
CREATE OR REPLACE FUNCTION procname1(args)
RETURNS void AS
$BODY$
DECLARE
{
---
Some code blocks
---
}
BEGIN
-- to here it is executing fastly after reaches
hello
Are you sure, so you don't call trigger recursion?
Regards
Pavel Stehule
2008/7/14 Praveen [EMAIL PROTECTED]:
Hi all,
Please find the procedure and trigger which took more time when we try to
update value in table through Procedure.
CREATE OR REPLACE FUNCTION procname1(args)
Yes , I am sure it is not trigger recursion.
- Original Message -
From: Pavel Stehule [EMAIL PROTECTED]
To: Praveen [EMAIL PROTECTED]
Cc: pgsql-performance@postgresql.org; [EMAIL PROTECTED]
Sent: Monday, July 14, 2008 3:03 PM
Subject: Re: [PERFORM] Trigger is not firing immediately
Hi guys !!!
Sorry for the wrong spelling. =)
I could see that PostgreSQL will support my application, but i have to do a
good configuration on my server.
Thanks for answers, now i will look for informations about PostgreSQL on
OpenSolaris 2008.05
Have a nice week,
Levi
2008/7/4 Chris Browne
On Sun, Jul 13, 2008 at 11:59 PM, Ramasubramanian
[EMAIL PROTECTED] wrote:
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
On Fri, 11 Jul 2008, Jeffrey Baker wrote:
Their firmware is, frankly, garbage. In more than one instance we
have had the card panic when a disk fails, which is obviously counter
to the entire purpose of a RAID. We finally removed the Areca
controllers from our database server and replaced