Re: performance of first exec of prepared statement - Mailing list pgsql-general

From Adrian Klaver
Subject Re: performance of first exec of prepared statement
Date
Msg-id 46565270-f610-a7ef-eff2-75e23ca27bcb@aklaver.com
Whole thread Raw
In response to Re: performance of first exec of prepared statement  (Ted Toth <txtoth@gmail.com>)
Responses Re: performance of first exec of prepared statement
List pgsql-general
On 4/16/20 4:59 PM, Ted Toth wrote:
> 
> 
> On Thu, Apr 16, 2020 at 6:29 PM Ted Toth <txtoth@gmail.com 
> <mailto: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.
> 

I don't have an answer. I believe though that to help those that might 
it would be helpful to show the actual code.


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Ted Toth
Date:
Subject: Re: performance of first exec of prepared statement
Next
From: Michael Paquier
Date:
Subject: Re: Using of --data-checksums