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

Поиск
Список
Период
Сортировка
От Robert B. Easter
Тема Is there any way to speed up PL/TCL functions?
Дата
Msg-id 00072401305903.00253@comptechnews
обсуждение исходный текст
Ответы Re: Is there any way to speed up PL/TCL functions?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: WaitOnLock error - what does this mean?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Is there any way to speed up PL/TCL functions?