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

pgsql: Skip eval_const_expressions when the query is such that the

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Skip eval_const_expressions when the query is such that the
Date: 2005-05-30 01:04:45
Message-ID: 20050530010445.26CB1528B7@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Skip eval_const_expressions when the query is such that the expression
would be evaluated only once anyway (ie, it's just a SELECT with no
FROM or an INSERT ... VALUES).  The planner can't do it any faster than
the executor, so no point in an extra copying of the expression tree.

Modified Files:
--------------
    pgsql/src/backend/optimizer/plan:
        planner.c (r1.186 -> r1.187)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/planner.c.diff?r1=1.186&r2=1.187)

pgsql-committers by date

Next:From: Tom LaneDate: 2005-05-30 01:20:50
Subject: pgsql: Change the UNKNOWN type to have an internal representation
Previous:From: Tom LaneDate: 2005-05-29 23:38:05
Subject: pgsql: Avoid unnecessary fetch from pg_shadow in the normal case in

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