]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: b66a0cc) | patch
Cause planner to make use of average-column-width statistic that is now
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 9 May 2001 00:35:09 +0000 (00:35 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 9 May 2001 00:35:09 +0000 (00:35 +0000)
commit6cda3ad8feb9b534fe9fb5866bbe5930596d0027
treeaf13dbf295f98b9f4addf5f18ddaf3dd8d2f9341tree | snapshot
parentb66a0cca57e21e2fdf00f81e1976bd76fabf0fc1commit | 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 ...
doc/src/sgml/perform.sgml diff | blob | history
src/backend/optimizer/path/costsize.c diff | blob | history
src/backend/utils/cache/lsyscache.c diff | blob | history
src/include/utils/lsyscache.h diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.