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 |
