Is there any way to speed up PL/TCL functions?

From: "Robert B(dot) Easter" <reaster(at)comptechnews(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Is there any way to speed up PL/TCL functions?
Date: 2000-07-24 05:15:00
Message-ID: 00072401305903.00253@comptechnews
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice pgsql-sql

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-07-24 05:26:56 Re: WaitOnLock error - what does this mean?
Previous Message Robert B. Easter 2000-07-24 04:57:01 Re: WaitOnLock error - what does this mean?

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2000-07-24 06:04:57 Re: Is there any way to speed up PL/TCL functions?
Previous Message John Burski 2000-07-22 14:16:43 Re: [NOVICE] pg_dump problem

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-07-24 06:04:57 Re: Is there any way to speed up PL/TCL functions?
Previous Message Mitch Vincent 2000-07-22 22:41:43 Re: query optimazation & starting postmaster with -B option