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

pgsql: Change addRangeTableEntryForRelation() to take a Relation pointer

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Change addRangeTableEntryForRelation() to take a Relation pointer
Date: 2005-04-13 16:50:55
Message-ID: 20050413165055.8026153685@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Change addRangeTableEntryForRelation() to take a Relation pointer instead
of just a relation OID, thereby not having to open the relation for itself.
This actually saves code rather than adding it for most of the existing
callers, which had the rel open already.  The main point though is to be
able to use this rather than plain addRangeTableEntry in setTargetTable,
thus saving one relation_openrv/relation_close cycle for every INSERT,
UPDATE, or DELETE.  Seems to provide a several percent win on simple
INSERTs.

Modified Files:
--------------
    pgsql/src/backend/catalog:
        heap.c (r1.281 -> r1.282)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/heap.c.diff?r1=1.281&r2=1.282)
    pgsql/src/backend/commands:
        tablecmds.c (r1.152 -> r1.153)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/tablecmds.c.diff?r1=1.152&r2=1.153)
        view.c (r1.88 -> r1.89)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/view.c.diff?r1=1.88&r2=1.89)
    pgsql/src/backend/parser:
        analyze.c (r1.318 -> r1.319)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/analyze.c.diff?r1=1.318&r2=1.319)
        parse_clause.c (r1.139 -> r1.140)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/parse_clause.c.diff?r1=1.139&r2=1.140)
        parse_relation.c (r1.105 -> r1.106)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/parse_relation.c.diff?r1=1.105&r2=1.106)
    pgsql/src/include/parser:
        parse_relation.h (r1.48 -> r1.49)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/parser/parse_relation.h.diff?r1=1.48&r2=1.49)

pgsql-committers by date

Next:From: User JwpDate: 2005-04-13 18:23:39
Subject: python - web: Fix broken links(sp -> project).
Previous:From: User JwpDate: 2005-04-13 16:38:47
Subject: python - web: Quiet removal of doc/ contents.

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