Is there any way to speed up PL/TCL functions? - Mailing list pgsql-general

From Robert B. Easter
Subject Is there any way to speed up PL/TCL functions?
Date
Msg-id 00072401305903.00253@comptechnews
Whole thread Raw
Responses Re: Is there any way to speed up PL/TCL functions?
List pgsql-general
I'm using some PL/TCL functions and triggers to do some special inserts.  When
I do an insert that uses these procedures, I get the "INSERT xxxxxx 1" response
back immediately, but then there is a pause before the next query is executed.
It appears as if the PL/TCL runs fast but after its finished it has to spend a
significant amount of time cleaning up before the next query can run.

Is this the way it is?  Any way to reduce this pause?

--
            - Robert

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: WaitOnLock error - what does this mean?
Next
From: Tom Lane
Date:
Subject: Re: Is there any way to speed up PL/TCL functions?