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

2008-07-13 Thread Ow Mun Heng
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/type. Because the

[PERFORM] Trigger is taking time to fire

2008-07-13 Thread Ramasubramanian
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