From 5cfb44a82ee6854cb986534af3ac819592b963d5 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Fri, 27 Feb 2004 21:44:44 +0000 Subject: [PATCH] genericcostestimate() neglected to include qual startup cost in indexTotalCost. I think this may not make any real difference in 7.4, but it definitely is a problem with CVS tip's new equation. --- src/backend/utils/adt/selfuncs.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/src/backend/utils/adt/selfuncs.c b/src/backend/utils/adt/selfuncs.c index 77986d4ca8b..34e4d767962 100644 --- a/src/backend/utils/adt/selfuncs.c +++ b/src/backend/utils/adt/selfuncs.c @@ -15,7 +15,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/utils/adt/selfuncs.c,v 1.147.2.2 2004/02/02 03:07:14 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/utils/adt/selfuncs.c,v 1.147.2.3 2004/02/27 21:44:44 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -3977,7 +3977,7 @@ genericcostestimate(Query *root, RelOptInfo *rel, */ cost_qual_eval(&index_qual_cost, indexQuals); *indexStartupCost = index_qual_cost.startup; - *indexTotalCost = numIndexPages + + *indexTotalCost = numIndexPages + index_qual_cost.startup + (cpu_index_tuple_cost + index_qual_cost.per_tuple) * numIndexTuples; /* -- 2.39.5