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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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)

Browse pgsql-committers by date

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