Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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)

pgsql-committers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group