Received: from comptechnews.com (root@cc993546-b.srst1.fl.home.com [24.3.77.52]) by hub.org (8.10.1/8.10.1) with ESMTP id e6O5T3h16395 for ; Mon, 24 Jul 2000 01:29:03 -0400 (EDT) Received: from comptechnews (reaster@localhost [127.0.0.1]) by comptechnews.com (8.9.3/8.9.3) with SMTP id BAA02468 for ; Mon, 24 Jul 2000 01:31:00 -0400 From: "Robert B. Easter" To: pgsql-general@postgresql.org Subject: Is there any way to speed up PL/TCL functions? Date: Mon, 24 Jul 2000 01:15:00 -0400 X-Mailer: KMail [version 1.0.28] Content-Type: text/plain MIME-Version: 1.0 Message-Id: <00072401305903.00253@comptechnews> Content-Transfer-Encoding: 8bit X-Archive-Number: 200007/833 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