Re: FE/BE protocol vs. parameterized queries

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: andrew(at)supernews(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: FE/BE protocol vs. parameterized queries
Date: 2006-09-04 21:30:04
Message-ID: 13214.1157405404@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andrew - Supernews <andrew+nonews(at)supernews(dot)com> writes:
> I believe this could usefully (and transparently to clients) be changed
> so that Bind on the unnamed statement does _not_ store the plan back in
> the unnamed statement's context, but instead produces a plan which is
> only used _for that specific portal_.

That seems OK to me, since we document the unnamed statement/portal as
being optimized for one-shot execution. Unfortunately it's probably
less than a trivial change, because the planner never assumes that
Params are constants; that would have to be changed somehow.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2006-09-04 21:30:51 Re: [HACKERS] Unable to post to -patches (was: Visual C++
Previous Message Bruce Momjian 2006-09-04 21:23:37 Re: Have psql show current sequnce values -