| From: | Tom Lane <tgl(at)hub(dot)org> |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql/ rc/include/utils/lsyscache.h rc/backend ... |
| Date: | 2001-05-09 00:35:10 |
| Message-ID: | 200105090035.f490ZAw93767@hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
CVSROOT: /home/projects/pgsql/cvsroot
Module name: pgsql
Changes by: tgl(at)hub(dot)org 01/05/08 20:35:09
Modified files:
src/include/utils: lsyscache.h
src/backend/utils/cache: lsyscache.c
src/backend/optimizer/path: costsize.c
doc/src/sgml : perform.sgml
Log message:
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 ...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian - CVS | 2001-05-09 13:27:15 | pgsql/doc/src/sgml/ref alter_table.sgml |
| Previous Message | Tom Lane | 2001-05-08 22:19:38 | Re: pgsql/ oc/src/sgml/reference.sgml oc/src/sgml/ ... |