Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimizing the same PREPAREd static query (without parameters) - Mailing list pgsql-general

From David Rowley
Subject Re: Optimizing the same PREPAREd static query (without parameters)
Date
Msg-id CAKJS1f-oH6BOMgfDMveMd69TDuaxVn8eK0+eWmBv1s9bDmPV-g@mail.gmail.com
Whole thread Raw
In response to Optimizing the same PREPAREd static query (without parameters)  (Mitar <mmitar@gmail.com>)
Responses Re: Optimizing the same PREPAREd static query (without parameters)  (Mitar <mmitar@gmail.com>)
List pgsql-general
Tree view 
On Mon, 7 Jan 2019 at 18:54, Mitar <mmitar@gmail.com> wrote:
> If I have a PREPAREd query without parameters (static) and I EXECUTE
> it repeatedly in the same session, does PostgreSQL learn/optimize
> anything across those runs?

Yes, it will generate the query plan on the first invocation of
EXECUTE and use that plan for all subsequent EXECUTEs for the session
until you DEALLOCATE the prepared query or DISCARD PLANS/ALL;

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-general by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: Use bytearray for blobs or not?
Next
From: Mitar
Date:
Subject: Re: Optimizing the same PREPAREd static query (without parameters)