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
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? |
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 |
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 |