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

pgsql: Add an 'enable_material' GUC.

From: rhaas(at)postgresql(dot)org (Robert Haas)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add an 'enable_material' GUC.
Date: 2010-04-19 00:55:26
Message-ID: 20100419005526.448FD7541D0@cvs.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Add an 'enable_material' GUC.

The logic for determining whether to materialize has been significantly
overhauled for 9.0.  In case there should be any doubt about whether
materialization is a win in any particular case, this should provide a
convenient way of seeing what happens without it; but even with enable_material
turned off, we still materialize in cases where it is required for
correctness.

Thanks to Tom Lane for the review.

Modified Files:
--------------
    pgsql/doc/src/sgml:
        config.sgml (r1.267 -> r1.268)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/config.sgml?r1=1.267&r2=1.268)
    pgsql/src/backend/optimizer/path:
        costsize.c (r1.216 -> r1.217)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/costsize.c?r1=1.216&r2=1.217)
        joinpath.c (r1.132 -> r1.133)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/joinpath.c?r1=1.132&r2=1.133)
    pgsql/src/backend/optimizer/plan:
        subselect.c (r1.161 -> r1.162)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/subselect.c?r1=1.161&r2=1.162)
    pgsql/src/backend/utils/misc:
        guc.c (r1.547 -> r1.548)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/guc.c?r1=1.547&r2=1.548)
        postgresql.conf.sample (r1.282 -> r1.283)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/postgresql.conf.sample?r1=1.282&r2=1.283)
    pgsql/src/include/optimizer:
        cost.h (r1.100 -> r1.101)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/cost.h?r1=1.100&r2=1.101)
    pgsql/src/test/regress/expected:
        rangefuncs.out (r1.24 -> r1.25)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/rangefuncs.out?r1=1.24&r2=1.25)

pgsql-committers by date

Next:From: User MkzDate: 2010-04-19 07:05:46
Subject: pgbouncer - pgbouncer: Increase room for DateStyle storage.
Previous:From: Robert HaasDate: 2010-04-19 00:00:22
Subject: pgsql: Provide better guidance for adjusting shared_buffers.

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