granicus.if.org Git - postgresql/commit

]> granicus.if.org Git - postgresql/commit

author	Tom Lane <tgl@sss.pgh.pa.us>
	Tue, 29 Dec 2009 20:11:45 +0000 (20:11 +0000)
committer	Tom Lane <tgl@sss.pgh.pa.us>
	Tue, 29 Dec 2009 20:11:45 +0000 (20:11 +0000)
commit	649b5ec7c8a3050a30bd6d36003ba3a681c9a198
tree	af041b646426d71d9ea1113837b5f7a9001082c9	tree \| snapshot
parent	84d723b6cefcf25b8c800f8aa6cf3c9538a546b4	commit \| diff

Add the ability to store inheritance-tree statistics in pg_statistic,
and teach ANALYZE to compute such stats for tables that have subclasses.
Per my proposal of yesterday.

autovacuum still needs to be taught about running ANALYZE on parent tables
when their subclasses change, but the feature is useful even without that.

18 files changed:

doc/src/sgml/catalogs.sgml		diff \| blob \| history
src/backend/catalog/heap.c		diff \| blob \| history
src/backend/catalog/system_views.sql		diff \| blob \| history
src/backend/commands/analyze.c		diff \| blob \| history
src/backend/commands/vacuum.c		diff \| blob \| history
src/backend/executor/nodeHash.c		diff \| blob \| history
src/backend/nodes/copyfuncs.c		diff \| blob \| history
src/backend/nodes/outfuncs.c		diff \| blob \| history
src/backend/optimizer/plan/createplan.c		diff \| blob \| history
src/backend/utils/adt/selfuncs.c		diff \| blob \| history
src/backend/utils/cache/lsyscache.c		diff \| blob \| history
src/backend/utils/cache/syscache.c		diff \| blob \| history
src/include/catalog/catversion.h		diff \| blob \| history
src/include/catalog/indexing.h		diff \| blob \| history
src/include/catalog/pg_statistic.h		diff \| blob \| history
src/include/nodes/plannodes.h		diff \| blob \| history
src/include/utils/syscache.h		diff \| blob \| history
src/test/regress/expected/rules.out		diff \| blob \| history

Unnamed repository; edit this file 'description' to name the repository.

RSS Atom