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

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Change processing of extended-Query mode so that an unnamed
Date
Msg-id 20060906204048.613EF9FB3B6@postgresql.org
Whole thread Raw
List 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@supernews.

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)

pgsql-committers by date:

Previous
From: dpage@pgfoundry.org (User Dpage)
Date:
Subject: psqlodbc - psqlodbc: Fix Makefile to include docs and installer
Next
From: agoldshuv@pgfoundry.org (User Agoldshuv)
Date:
Subject: bizgres - bizgres: BG-25.