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

pgsql: Tweak make_inh_translation_lists() to check the common case

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Tweak make_inh_translation_lists() to check the common case
Date: 2007-04-21 05:56:41
Message-ID: 20070421055641.DACF09FB1C6@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Tweak make_inh_translation_lists() to check the common case wherein parent and
child attnums are the same, before it grovels through each and every child
column looking for a name match.  Saves some time in large inheritance trees,
per example from Greg.

Modified Files:
--------------
    pgsql/src/backend/optimizer/prep:
        prepunion.c (r1.140 -> r1.141)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/prep/prepunion.c.diff?r1=1.140&r2=1.141)

pgsql-committers by date

Next:From: Tom LaneDate: 2007-04-21 06:18:53
Subject: pgsql: Avoid useless work during set_plain_rel_pathlist() when the
Previous:From: Tom LaneDate: 2007-04-21 04:49:20
Subject: pgsql: Improve the way in which CatalogCacheComputeHashValue combines

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