Re: [PERFORM] Trigger is not firing immediately

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 o

Re: [PERFORM] Trigger is not firing immediately

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 1

[PERFORM] Trigger is not firing immediately

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 t

[PERFORM] Trigger is taking time to fire

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 seconds per row). How can i make the trigger to fire immediately ? Regards, Ram

[SOLVED] Re: [PERFORM] Altering a column type - Most efficient way

On Fri, 2008-07-11 at 09:55 -0500, Kevin Grittner wrote: > > Alvaro Herrera <[EMAIL PROTECTED]> writes: > >>> Ow Mun Heng wrote: > >>> If it were this simple a change, I'm not certain why (I believe) PG > >>>is checking each and every row to see if it will fit into the new column > >>> definition/t