Measure the number of all-visible pages for use in index-only scan costing.
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 14 Oct 2011 21:23:01 +0000 (17:23 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 14 Oct 2011 21:23:46 +0000 (17:23 -0400)
commite6858e665731c0f56d3ecc9fbb245c32d24f8ef7
tree4df2705d53d53b1bbd7a14d7017cb519d82ee227
parentdea95c7a7beb5ef66ce89269dd0e84d0c26e5523
Measure the number of all-visible pages for use in index-only scan costing.

Add a column pg_class.relallvisible to remember the number of pages that
were all-visible according to the visibility map as of the last VACUUM
(or ANALYZE, or some other operations that update pg_class.relpages).
Use relallvisible/relpages, instead of an arbitrary constant, to estimate
how many heap page fetches can be avoided during an index-only scan.

This is pretty primitive and will no doubt see refinements once we've
acquired more field experience with the index-only scan mechanism, but
it's way better than using a constant.

Note: I had to adjust an underspecified query in the window.sql regression
test, because it was changing answers when the plan changed to use an
index-only scan.  Some of the adjacent tests perhaps should be adjusted
as well, but I didn't do that here.
22 files changed:
doc/src/sgml/catalogs.sgml
src/backend/access/hash/hash.c
src/backend/access/heap/visibilitymap.c
src/backend/catalog/heap.c
src/backend/catalog/index.c
src/backend/commands/analyze.c
src/backend/commands/cluster.c
src/backend/commands/vacuum.c
src/backend/commands/vacuumlazy.c
src/backend/nodes/outfuncs.c
src/backend/optimizer/path/costsize.c
src/backend/optimizer/util/plancat.c
src/backend/optimizer/util/relnode.c
src/backend/utils/cache/relcache.c
src/include/access/visibilitymap.h
src/include/catalog/catversion.h
src/include/catalog/pg_class.h
src/include/commands/vacuum.h
src/include/nodes/relation.h
src/include/optimizer/plancat.h
src/test/regress/expected/window.out
src/test/regress/sql/window.sql