diff options
| author | Tom Lane | 2001-05-09 00:35:09 +0000 |
|---|---|---|
| committer | Tom Lane | 2001-05-09 00:35:09 +0000 |
| commit | 6cda3ad8feb9b534fe9fb5866bbe5930596d0027 (patch) | |
| tree | af13dbf295f98b9f4addf5f18ddaf3dd8d2f9341 /src/include | |
| parent | b66a0cca57e21e2fdf00f81e1976bd76fabf0fc1 (diff) | |
Cause planner to make use of average-column-width statistic that is now
collected by ANALYZE. Also, add some modest amount of intelligence to
guesses that are used for varlena columns in the absence of any ANALYZE
statistics. The 'width' reported by EXPLAIN is finally something less
than totally bogus for varlena columns ... and, in consequence, hashjoin
estimating should be a little better ...
Diffstat (limited to 'src/include')
| -rw-r--r-- | src/include/utils/lsyscache.h | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/src/include/utils/lsyscache.h b/src/include/utils/lsyscache.h index 6b35deed28..3f18a4aea6 100644 --- a/src/include/utils/lsyscache.h +++ b/src/include/utils/lsyscache.h @@ -6,7 +6,7 @@ * Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $Id: lsyscache.h,v 1.31 2001/05/07 00:43:26 tgl Exp $ + * $Id: lsyscache.h,v 1.32 2001/05/09 00:35:09 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -39,6 +39,8 @@ extern bool get_typbyval(Oid typid); extern void get_typlenbyval(Oid typid, int16 *typlen, bool *typbyval); extern char get_typstorage(Oid typid); extern Datum get_typdefault(Oid typid); +extern int32 get_typavgwidth(Oid typid, int32 typmod); +extern int32 get_attavgwidth(Oid relid, AttrNumber attnum); extern bool get_attstatsslot(HeapTuple statstuple, Oid atttype, int32 atttypmod, int reqkind, Oid reqop, |