Plan chosen for PQexecParams - Mailing list pgsql-hackers

From Michael Fuhr
Subject Plan chosen for PQexecParams
Date
Msg-id 20051120205111.GA55457@winnie.fuhr.org
Whole thread Raw
Responses Re: Plan chosen for PQexecParams  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Data directory on read-only media
Next
From: Tom Lane
Date:
Subject: Re: Data directory on read-only media