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

pgsql: Some further performance tweaks for planning large inheritance

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Some further performance tweaks for planning large inheritance
Date: 2007-04-21 21:01:46
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-committerspgsql-patches
Log Message:
Some further performance tweaks for planning large inheritance trees that
are mostly excluded by constraints: do the CE test a bit earlier to save
some adjust_appendrel_attrs() work on excluded children, and arrange to
use array indexing rather than rt_fetch() to fetch RTEs in the main body
of the planner.  The latter is something I'd wanted to do for awhile anyway,
but seeing list_nth_cell() as 35% of the runtime gets one's attention.

Modified Files:
        allpaths.c (r1.162 -> r1.163)
        clausesel.c (r1.84 -> r1.85)
        costsize.c (r1.180 -> r1.181)
        createplan.c (r1.228 -> r1.229)
        planagg.c (r1.30 -> r1.31)
        planmain.c (r1.99 -> r1.100)
        pathnode.c (r1.138 -> r1.139)
        plancat.c (r1.133 -> r1.134)
        relnode.c (r1.86 -> r1.87)
        selfuncs.c (r1.232 -> r1.233)
        relation.h (r1.140 -> r1.141)


pgsql-committers by date

Next:From: Tom LaneDate: 2007-04-22 03:52:40
Subject: pgsql: Remove some of the most blatant brain-fade in the recent guc
Previous:From: Magnus HaganderDate: 2007-04-21 20:58:05
Subject: pgsql: Fix build for directories with spaces in them by quoting

pgsql-patches by date

Next:From: Tom LaneDate: 2007-04-21 23:21:10
Subject: Re: [HACKERS] parser dilemma
Previous:From: Zoltan BoszormenyiDate: 2007-04-21 08:49:46
Subject: Re: [HACKERS] parser dilemma

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