Postgres Pro
Downloads
Home   >   mailing lists

Triggers and speed - 7.4.5 / 8.0.3 - Mailing list pgsql-novice

From Steve Tucknott
Subject Triggers and speed - 7.4.5 / 8.0.3
Date
Msg-id 1136812333.2797.96.camel@retsol1
Whole thread Raw
Responses Re: Triggers and speed - 7.4.5 / 8.0.3  (Sean Davis <sdavis2@mail.nih.gov>)
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: how to list all tables in a database
Next
From: Sean Davis
Date:
Subject: Re: Triggers and speed - 7.4.5 / 8.0.3