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: performance of first exec of prepared statement
Date: 2020-04-16 23:29:43
Message-ID: CAFPpqQGfvPcSjvJ6t8Bibv_MdxXix=s54C0P-JQP5BCc6SqtwA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ted Toth 2020-04-16 23:59:57 Re: performance of first exec of prepared statement
Previous Message Tim Cross 2020-04-16 23:21:11 Re: Using unlogged tables for web sessions