Postgres Pro
Downloads
Home   >   mailing lists

bizgres - bizgres: Teach nodeSort and nodeMaterial to optimize out - Mailing list pgsql-committers

From aparashar@pgfoundry.org (User Aparashar)
Subject bizgres - bizgres: Teach nodeSort and nodeMaterial to optimize out
Date
Msg-id 20060322072751.A6AC9103384D@pgfoundry.org
Whole thread Raw
List pgsql-committers
Tree view 
Log Message:
-----------
Teach nodeSort and nodeMaterial to optimize out unnecessary overhead when the passed-down eflags indicate they can.
SimonRiggs and Tom Lane 

Modified Files:
--------------
    bizgres/postgresql/src/backend/executor:
        nodeAgg.c (r1.1.1.2.2.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/executor/nodeAgg.c.diff?r1=1.1.1.2.2.1&r2=1.2)
        nodeAppend.c (r1.1.1.2.2.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/executor/nodeAppend.c.diff?r1=1.1.1.2.2.1&r2=1.2)
        nodeBitmapAnd.c (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/executor/nodeBitmapAnd.c.diff?r1=1.3&r2=1.4)
        nodeBitmapHeapscan.c (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/executor/nodeBitmapHeapscan.c.diff?r1=1.3&r2=1.4)
        nodeBitmapIndexscan.c (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/executor/nodeBitmapIndexscan.c.diff?r1=1.3&r2=1.4)
        nodeBitmapOr.c (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/executor/nodeBitmapOr.c.diff?r1=1.3&r2=1.4)
        nodeFunctionscan.c (r1.1.1.2.2.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/executor/nodeFunctionscan.c.diff?r1=1.1.1.2.2.1&r2=1.2)
        nodeGroup.c (r1.1.1.2.2.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/executor/nodeGroup.c.diff?r1=1.1.1.2.2.1&r2=1.2)
        nodeHash.c (r1.1.1.2.2.1 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/executor/nodeHash.c.diff?r1=1.1.1.2.2.1&r2=1.3)
        nodeHashjoin.c (r1.1.1.2.2.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/executor/nodeHashjoin.c.diff?r1=1.1.1.2.2.1&r2=1.2)
        nodeIndexscan.c (r1.1.1.2.2.1 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/executor/nodeIndexscan.c.diff?r1=1.1.1.2.2.1&r2=1.3)
        nodeLimit.c (r1.1.1.2.2.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/executor/nodeLimit.c.diff?r1=1.1.1.2.2.1&r2=1.2)
        nodeMaterial.c (r1.1.1.2.2.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/executor/nodeMaterial.c.diff?r1=1.1.1.2.2.1&r2=1.2)
        nodeMergejoin.c (r1.1.1.2.2.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/executor/nodeMergejoin.c.diff?r1=1.1.1.2.2.1&r2=1.2)
        nodeNestloop.c (r1.1.1.2.2.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/executor/nodeNestloop.c.diff?r1=1.1.1.2.2.1&r2=1.2)
        nodeResult.c (r1.1.1.2.2.1 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/executor/nodeResult.c.diff?r1=1.1.1.2.2.1&r2=1.3)
        nodeSeqscan.c (r1.1.1.2.2.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/executor/nodeSeqscan.c.diff?r1=1.1.1.2.2.1&r2=1.2)
        nodeSetOp.c (r1.1.1.2.2.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/executor/nodeSetOp.c.diff?r1=1.1.1.2.2.1&r2=1.2)
        nodeSort.c (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/executor/nodeSort.c.diff?r1=1.2&r2=1.3)
        nodeSubplan.c (r1.1.1.2.2.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/executor/nodeSubplan.c.diff?r1=1.1.1.2.2.1&r2=1.2)
        nodeSubqueryscan.c (r1.1.1.2.2.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/executor/nodeSubqueryscan.c.diff?r1=1.1.1.2.2.1&r2=1.2)
        nodeTidscan.c (r1.1.1.2.2.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/executor/nodeTidscan.c.diff?r1=1.1.1.2.2.1&r2=1.2)
        nodeUnique.c (r1.1.1.2.2.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/executor/nodeUnique.c.diff?r1=1.1.1.2.2.1&r2=1.2)
        spi.c (r1.1.1.3.2.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/executor/spi.c.diff?r1=1.1.1.3.2.1&r2=1.2)
    bizgres/postgresql/src/include/executor:
        executor.h (r1.1.1.2.2.1 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/executor/executor.h.diff?r1=1.1.1.2.2.1&r2=1.3)
        nodeAgg.h (r1.1.1.2.2.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/executor/nodeAgg.h.diff?r1=1.1.1.2.2.1&r2=1.2)
        nodeAppend.h (r1.1.1.1.30.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/executor/nodeAppend.h.diff?r1=1.1.1.1.30.1&r2=1.2)
        nodeBitmapAnd.h (r1.1.1.1.2.1 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/executor/nodeBitmapAnd.h.diff?r1=1.1.1.1.2.1&r2=1.3)
        nodeBitmapHeapscan.h (r1.1.1.1.2.1 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/executor/nodeBitmapHeapscan.h.diff?r1=1.1.1.1.2.1&r2=1.3)
        nodeBitmapIndexscan.h (r1.1.1.1.2.1 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/executor/nodeBitmapIndexscan.h.diff?r1=1.1.1.1.2.1&r2=1.3)
        nodeBitmapOr.h (r1.1.1.1.2.1 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/executor/nodeBitmapOr.h.diff?r1=1.1.1.1.2.1&r2=1.3)
        nodeFunctionscan.h (r1.1.1.1.30.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/executor/nodeFunctionscan.h.diff?r1=1.1.1.1.30.1&r2=1.2)
        nodeGroup.h (r1.1.1.1.30.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/executor/nodeGroup.h.diff?r1=1.1.1.1.30.1&r2=1.2)
        nodeHash.h (r1.1.1.2.2.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/executor/nodeHash.h.diff?r1=1.1.1.2.2.1&r2=1.2)
        nodeHashjoin.h (r1.1.1.2.2.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/executor/nodeHashjoin.h.diff?r1=1.1.1.2.2.1&r2=1.2)
        nodeIndexscan.h (r1.1.1.2.2.1 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/executor/nodeIndexscan.h.diff?r1=1.1.1.2.2.1&r2=1.3)
        nodeLimit.h (r1.1.1.1.30.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/executor/nodeLimit.h.diff?r1=1.1.1.1.30.1&r2=1.2)
        nodeMaterial.h (r1.1.1.1.30.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/executor/nodeMaterial.h.diff?r1=1.1.1.1.30.1&r2=1.2)
        nodeMergejoin.h (r1.1.1.1.30.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/executor/nodeMergejoin.h.diff?r1=1.1.1.1.30.1&r2=1.2)
        nodeNestloop.h (r1.1.1.1.30.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/executor/nodeNestloop.h.diff?r1=1.1.1.1.30.1&r2=1.2)
        nodeResult.h (r1.1.1.1.30.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/executor/nodeResult.h.diff?r1=1.1.1.1.30.1&r2=1.2)
        nodeSeqscan.h (r1.1.1.1.30.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/executor/nodeSeqscan.h.diff?r1=1.1.1.1.30.1&r2=1.2)
        nodeSetOp.h (r1.1.1.1.30.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/executor/nodeSetOp.h.diff?r1=1.1.1.1.30.1&r2=1.2)
        nodeSort.h (r1.1.1.1.30.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/executor/nodeSort.h.diff?r1=1.1.1.1.30.1&r2=1.2)
        nodeSubplan.h (r1.1.1.1.30.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/executor/nodeSubplan.h.diff?r1=1.1.1.1.30.1&r2=1.2)
        nodeSubqueryscan.h (r1.1.1.1.30.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/executor/nodeSubqueryscan.h.diff?r1=1.1.1.1.30.1&r2=1.2)
        nodeTidscan.h (r1.1.1.1.30.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/executor/nodeTidscan.h.diff?r1=1.1.1.1.30.1&r2=1.2)
        nodeUnique.h (r1.1.1.1.30.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/executor/nodeUnique.h.diff?r1=1.1.1.1.30.1&r2=1.2)
    bizgres/postgresql/src/include/nodes:
        execnodes.h (r1.4 -> r1.5)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/include/nodes/execnodes.h.diff?r1=1.4&r2=1.5)

pgsql-committers by date:

Previous
From: aparashar@pgfoundry.org (User Aparashar)
Date:
Subject: bizgres - bizgres: Teach nodeSort and nodeMaterial to optimize out
Next
From: aparashar@pgfoundry.org (User Aparashar)
Date:
Subject: bizgres - bizgres: Tom Lane, Simon Riggs 1.