Re: performance of first exec of prepared statement

Поиск
Список
Период
Сортировка
От Ted Toth
Тема Re: performance of first exec of prepared statement
Дата
Msg-id CAFPpqQEmfVKRJ7KSJtAKi1vUusXYMyBuW85NPqqqLP17Z8gKDg@mail.gmail.com
обсуждение исходный текст
Ответ на performance of first exec of prepared statement  (Ted Toth <txtoth@gmail.com>)
Ответы Re: performance of first exec of prepared statement
Список pgsql-general


On Thu, Apr 16, 2020 at 6:29 PM Ted Toth <txtoth@gmail.com> wrote:
I've noticed that the first exec of an INSERT prepared statement takes ~5 time longer (I'm using libpq in C and wrapping the calls to time them) then subsequent exec's is this the expected behavior and if so is there any thing I can do to mitigate this affect?

Ted

For example (in my environment) I'm seeing the prepare take ~10ms, the first exec take ~30 ms and subsequent exec's take ~4 ms.

В списке pgsql-general по дате отправления:

Предыдущее
От: Ted Toth
Дата:
Сообщение: performance of first exec of prepared statement
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: performance of first exec of prepared statement