From afcf09dd9034f24e34dd46f69938882ab5b103d2 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sat, 21 Apr 2007 21:01:45 +0000 Subject: 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. --- src/backend/utils/adt/selfuncs.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'src/backend/utils') diff --git a/src/backend/utils/adt/selfuncs.c b/src/backend/utils/adt/selfuncs.c index 28e95a74eed..079f5e2cc9d 100644 --- a/src/backend/utils/adt/selfuncs.c +++ b/src/backend/utils/adt/selfuncs.c @@ -15,7 +15,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/adt/selfuncs.c,v 1.232 2007/04/06 22:33:42 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/utils/adt/selfuncs.c,v 1.233 2007/04/21 21:01:45 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -3487,7 +3487,7 @@ examine_variable(PlannerInfo *root, Node *node, int varRelid, vardata->atttype = var->vartype; vardata->atttypmod = var->vartypmod; - rte = rt_fetch(var->varno, root->parse->rtable); + rte = root->simple_rte_array[var->varno]; if (rte->inh) { -- cgit v1.2.3