We have both 7.4.5 and 8.0.3 running and seem to have some speed
problems with triggers/procedures in both.
We are using PL/pgSQL for the procedures. Is this a known issue that is
cured in later releases?
The speed problem appears to be more related to the fact that an action
has a trigger, rather than the action that the trigger spawns. IE the
triggered procedure code seems to execute ok in stand-alone, but seems
to take time load/execute. Is there a way of compiling the procedure(s)
or something similar?
Regards,
Steve Tucknott
ReTSol Ltd
DDI: 01903 828769
Mobile: 0773 671 5772