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/ -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance