pgsql: Change processing of extended-Query mode so that an unnamed

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Change processing of extended-Query mode so that an unnamed
Date: 2006-09-06 20:40:48
Message-ID: 20060906204048.613EF9FB3B6@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Change processing of extended-Query mode so that an unnamed statement
that has parameters is always planned afresh for each Bind command,
treating the parameter values as constants in the planner. This removes
the performance penalty formerly often paid for using out-of-line
parameters --- with this definition, the planner can do constant folding,
LIKE optimization, etc. After a suggestion by Andrew(at)supernews(dot)

Modified Files:
--------------
pgsql/doc/src/sgml:
protocol.sgml (r1.65 -> r1.66)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/protocol.sgml.diff?r1=1.65&r2=1.66)
pgsql/src/backend/commands:
explain.c (r1.150 -> r1.151)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/explain.c.diff?r1=1.150&r2=1.151)
portalcmds.c (r1.53 -> r1.54)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/portalcmds.c.diff?r1=1.53&r2=1.54)
prepare.c (r1.62 -> r1.63)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/prepare.c.diff?r1=1.62&r2=1.63)
pgsql/src/backend/executor:
functions.c (r1.105 -> r1.106)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/functions.c.diff?r1=1.105&r2=1.106)
spi.c (r1.161 -> r1.162)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/spi.c.diff?r1=1.161&r2=1.162)
pgsql/src/backend/optimizer/util:
clauses.c (r1.219 -> r1.220)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/clauses.c.diff?r1=1.219&r2=1.220)
pgsql/src/backend/tcop:
postgres.c (r1.505 -> r1.506)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/tcop/postgres.c.diff?r1=1.505&r2=1.506)
pgsql/src/include/nodes:
params.h (r1.31 -> r1.32)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/params.h.diff?r1=1.31&r2=1.32)
pgsql/src/pl/plpgsql/src:
pl_exec.c (r1.177 -> r1.178)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpgsql/src/pl_exec.c.diff?r1=1.177&r2=1.178)

Browse pgsql-committers by date

  From Date Subject
Next Message User Agoldshuv 2006-09-06 21:07:17 bizgres - bizgres: BG-25.
Previous Message User Dpage 2006-09-06 18:49:41 psqlodbc - psqlodbc: Fix Makefile to include docs and installer