Re: PQexecParams performance - Mailing list pgsql-bugs

From Tom Lane
Subject Re: PQexecParams performance
Date
Msg-id 2448.1134428170@sss.pgh.pa.us
Whole thread Raw
In response to PQexecParams performance  ("Harry Rossignol" <harrywr2@comcast.net>)
List pgsql-bugs
"Harry Rossignol" <harrywr2@comcast.net> writes:
> My experience using PQexecParams is that it has a performance
> degradation of a factor of 100's if not thousands.

This is demonstrably not so in general.  You may be hitting a case where
the planner chooses a poor plan for lack of information about the value
of a parameter ... but with no details about the query or even mention
of which PG version you're talking about, this bug report isn't worth
the electrons it's written on.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Harry Rossignol"
Date:
Subject: PQexecParams performance
Next
From: Andreas Pflug
Date:
Subject: COPY TO STDOUT BINARY