Re: Performance of query (fwd) - Mailing list pgsql-general

From Tom Lane
Subject Re: Performance of query (fwd)
Date
Msg-id 25349.1055385616@sss.pgh.pa.us
Whole thread Raw
In response to Re: Performance of query (fwd)  (Edmund Dengler <edmundd@eSentire.com>)
Responses Re: Performance of query (fwd)  (Edmund Dengler <edmundd@eSentire.com>)
List pgsql-general
Edmund Dengler <edmundd@eSentire.com> writes:
> Interesting. This brings up a quick question. If a "prepare" statement is
> run, and then values are passed in, does the plan stay the same regardless
> of the values? Or is a second pass made to re-optimize the plan?

AFAICS, the entire *point* of a prepared statement is that the plan is
computed just once for multiple uses.

            regards, tom lane

pgsql-general by date:

Previous
From: "Maksim Likharev"
Date:
Subject: Re: Postgres performance comments from a MySQL user
Next
From: darren@crystalballinc.com
Date:
Subject: Re: createdb for new user?