Plan chosen for PQexecParams

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Plan chosen for PQexecParams
Date: 2005-11-20 20:51:11
Message-ID: 20051120205111.GA55457@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I've noticed that if a client uses PQexecParams, the query plan
appears to be identical to the plan chosen for PQprepare/PQexecPrepared,
which might not be as optimal as a plan chosen for PQexec. I can
understand the PQprepare case since the planner doesn't know what
parameters will actually be used, but with PQexecParams shouldn't
the planner have all the information it needs to choose a plan based
on specific parameters? Is PQexecParams just shorthand for a prepare
followed by an execute?

--
Michael Fuhr

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-11-20 20:53:38 Re: Data directory on read-only media
Previous Message Tom Lane 2005-11-20 20:41:36 Re: Returning multiple result sets