Re: performance of first exec of prepared statement

From: Ted Toth <txtoth(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: performance of first exec of prepared statement
Date: 2020-04-16 23:59:57
Message-ID: CAFPpqQEmfVKRJ7KSJtAKi1vUusXYMyBuW85NPqqqLP17Z8gKDg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Apr 16, 2020 at 6:29 PM Ted Toth <txtoth(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-04-17 00:15:48 Re: performance of first exec of prepared statement
Previous Message Ted Toth 2020-04-16 23:29:43 performance of first exec of prepared statement